Adding Spreadsheet URLs to Google Sheets Columns Explained

Yes, you can add a spreadsheet URL from one of your columns. When setting up the Google Sheets integration: ** Click Add Enrichment ** Search for "Google Sheets" ** Select your desired action (Add Row, Lookup Row, etc.) ** Paste your Google Sheets URL in the URL field ** Select the sheet name ** Type / and select the relevant column(s) that contain your spreadsheet URLs ** Click *Save The integration accepts any Google Spreadsheet URL that you have read access to.

Sources: Google Sheets integration overview | Documentation | Clay University Google Sheets [Clay 101] - Clay University

Hey Kaushik - Do you mind sending the link (url) to the clay table so we can take a look? Thanks!

Got it, thanks! Let me take a look.

Thanks for your patience. I took a deeper look and the Google Sheets enrichment requires a static spreadsheet URL to be pasted directly in the URL field to set it up correctly. If you paste in the spreadsheet URL, you should be able to add rows. I have attached a short screen recording below to walk you through the steps. Also, you can find more information about the google sheets integration in these links below: ** https://www.clay.com/university/guide/google-sheets-integration-overview ** https://www.clay.com/university/lesson/google-sheets-clay-101 I hope this helps!

Unfortunately, not yet. When you enter a spreadsheet URL, Clay reads the columns and structure of that specific sheet to configure the lookup settings, column mappings, and field selections. Clay wouldn't know which sheet structure to use for the configuration if the spreadsheet URL changed on a row by row basis.

But this is fantastic feedback for the team! I will definitely take it back to the right people internally. Thank you!

I hope this helps - please let me know if you have any other questions.