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.
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.