Need Help Connecting Google Sheets to a List | Clay

Need Help Connecting Google Sheets to a List

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

18 comments

Channeled
APP
·
·
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.
Sources: Google Sheets [Clay 101] - Clay University Google Sheets integration overview | Documentation | Clay University
Channeled
APP
·
·
Brayan
·
·
https://app.clay.com/workspaces/286951/workbooks/wb_xaS9UFwdeUjz/tables/t_nCFnXmdmpXte/views/gv_KiqedSeFMfQt
Brayan
·
·
this is the sheet https://docs.google.com/spreadsheets/d/1Vqoa57VSV1SZaHBS-MdeBMi-Uqn15dFaitXkufQ-AIQ/edit?gid=1188976196#gid=1188976196
Bo (.
·
·
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!
(3691 kB)
Brayan
·
·
Hi team I added the sheet but when i run it it doesnt export to the sheet, am i doing something wrong?
Bo (.
·
·
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)?
(4192 kB)
Brayan
·
·
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
Brayan
·
·
but it shows an error
Brayan
·
·
Bo (.
·
·
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?
Brayan
·
·
What are header values
Bo (.
·
·
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.
(803 kB)
Brayan
·
·
Thanks for the clarification I’ve added the Header values but nothing comes up so you know why ? Thanks for your help
Bo (.
·
·
You need to click on the company name, press forward slash, and then select the value you want to add - See here :)
(2649 kB)
Brayan
·
·
It finally worked! Man thank you I’ve been dealing with this all week hahaha thank you thank you !!!
Bo (.
·
·
Great! Keep us posted if you need anything else. Would love to help! :)
Brayan
·
·
Sound good thank you!