Adding Spreadsheet URLs to Google Sheets Columns Explained

Kaushik K. · 2025-08-11T13:27:41.577Z

Can i not add a spreadsheet url from one of my columns in the google sheet column?

Adding Spreadsheet URLs to Google Sheets Columns Explained | Clay

14 comments

· Sorted by Oldest

Clay
APP
·
·
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
Kaushik K.
·
·
when i press forward slash, i’m getting a No matching columns found error
Loading attachments
Kaushik K.
·
·
i added the spreadsheetUrl but i see no option to add the sheetId
Loading attachments
Clay
APP
·
·
Hey Kaushik - Do you mind sending the link (url) to the clay table so we can take a look? Thanks!
(52 kB)
Kaushik K.
·
·
https://app.clay.com/workspaces/13871/workbooks/wb_0t0tymgx5vUMFcjbVkB/tables/t_0t0type7sYEQV8Gkrbj/views/gv_0t0typeW66Grb76Dnkp
Kaushik K.
·
·
here
Clay
APP
·
·
Got it, thanks! Let me take a look.
Kaushik K.
·
·
any update?
Clay
APP
·
·
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!
Channeled
APP
·
·
Kaushik K.
·
·
is there no way to make the google sheet id a variable instead of a hardcoded one?
Clay
APP
·
·
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.
Clay
APP
·
·
But this is fantastic feedback for the team! I will definitely take it back to the right people internally. Thank you!
Clay
APP
·
·
I hope this helps - please let me know if you have any other questions.

Clay
APP
·
·
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
Kaushik K.
·
·
when i press forward slash, i’m getting a No matching columns found error
Loading attachments
Kaushik K.
·
·
i added the spreadsheetUrl but i see no option to add the sheetId
Loading attachments
Clay
APP
·
·
Hey Kaushik - Do you mind sending the link (url) to the clay table so we can take a look? Thanks!
(52 kB)
Kaushik K.
·
·
https://app.clay.com/workspaces/13871/workbooks/wb_0t0tymgx5vUMFcjbVkB/tables/t_0t0type7sYEQV8Gkrbj/views/gv_0t0typeW66Grb76Dnkp
Kaushik K.
·
·
here
Clay
APP
·
·
Got it, thanks! Let me take a look.
Kaushik K.
·
·
any update?
Clay
APP
·
·
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!
Channeled
APP
·
·
Kaushik K.
·
·
is there no way to make the google sheet id a variable instead of a hardcoded one?
Clay
APP
·
·
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.
Clay
APP
·
·
But this is fantastic feedback for the team! I will definitely take it back to the right people internally. Thank you!
Clay
APP
·
·
I hope this helps - please let me know if you have any other questions.