Hi team I want to connect a google sheet to a list but when I put the link of the sheet it doesn't let me save it, I'm an editor can you please help? Thanks
To connect a Google Sheet to a Clay list, follow these steps: 1. Make sure you're on Clay's Starter plan ($149/mo) or higher, as the Google Sheets integration isn't available on the free plan. 2. Go to your Clay table and click "Add Enrichment". 3. Search for "Google Sheets" and select the appropriate action (e.g., "Add Row"). 4. Click "Add Account" and sign into your Google account. 5. Name your account and click "Save". 6. Paste your Google Sheets URL. 7. Select the sheet name and map the relevant columns. 8. Click "Save". If you're still having trouble saving the link, double-check that you have the correct permissions on the Google Sheet. If the issue persists, you may need to request human assistance for further troubleshooting.
Hi Brayan, Looks like everything is working on my end. Can you let me know what other trouble you're having? Let me know if you need more help!
Hi team I added the sheet but when i run it it doesnt export to the sheet, am i doing something wrong?
Hey Brayan - I don't see this in the table you sent. Can you make sure to select a sheet, then add the values to the respective rows and run the enrichment again? I don't see this when I go in your table (see gif)?
Hello, i tried using the Account manager 2.0 list, https://app.clay.com/workspaces/286951/workbooks/wb_dyutFcgb77Xg/tables/t_RfP6GjbaKmJV/views/gv_JCcPFZmZtBpp
but it shows an error
Hey Brayan,
Now if you click on the error, you will see the reason why. If we check it's saying: No values in the header row - fill the first row with header values before trying to interact with rows.
Can you do so?
What are header values
Great question. Those are the values you add in the first row of the Google Sheet. They will be considered the header for all the following rows. See the gif for how to add them (name1, name2). Then you'll be able to go back to the Google Sheet integration in Clay, refresh the fields, and you'll see those values appear. You can then add the values from Clay you want in those rows with the forward slash.
Thanks for the clarification Iβve added the Header values but nothing comes up so you know why ? Thanks for your help
You need to click on the company name, press forward slash, and then select the value you want to add - See here :)
It finally worked! Man thank you Iβve been dealing with this all week hahaha thank you thank you !!!
Great! Keep us posted if you need anything else. Would love to help! :)
Sound good thank you!