Troubleshooting Google Sheets Lookup and Update Issues

Hi Guys, I tried a few times on my own to no avail. In trying to use Lookup, Add, or Update Google Sheets, I was unable to determine what the Missing Input is. When i test with Add Row it says it was successful but I see no rows added to my spreadsheet. Ultimately I would like to have the Google Sheet filled with info from this table: https://app.clay.com/workspaces/134381/tables/t_2M88EsJWfvzC/views/gv_vsjMxqfkCoxZ In watching this video: https://www.loom.com/share/a0b1aae635ab43cda814aaab4542c5e8 , I didn't see the fields/columns that Patrick had access to. Did something change or is that what I'm missing? Please and than you for your help.

2 comments

Channeled
APP
·
·
First, please note that you'll need to be on Clay's Starter plan ($149/mo) to use the Google Sheets integration, as it's not available on the free plan.To successfully add rows to your Google Sheet: 1. Ensure your Google account has read and write access to the sheet you want to modify. 2. Follow these steps: • Click "Add Enrichment" • Search for "Google Sheets" • Select the appropriate action • Add your Google account if not already connected • Paste your Google Spreadsheet URL • Select the Sheet ID • Map out the corresponding columnsIf you're using the Lookup, Add, or Update function, make sure to: ** Specify the Lookup Column and Value ** Configure the row behavior by toggling "Add a row if no existing rows are found" or "Update row(s) if existing rows are found"If you need further assistance or if these steps don't resolve your issue, please request human assistance by clicking on "Talk to a person". Sources: Google Sheets - Clay University Google Sheets [Clay 101] - Clay University
Channeled
APP
·
·
This thread was picked up by our in-app web widget and will no longer sync to Slack. If you are the original poster, you can continue this conversation by logging into https://app.clay.com and clicking "Support" in the sidebar. If you're not the original poster and require help from support, please post in 02 Support.