Trouble Exporting Data from Clay to Google Sheets? Get Help!

Brayan · 2025-03-25 14:30:19.318224+00

Hi team I added a google sheet link to a Clay table to automatically export it from Clay to the google sheet, it shows that Clay added the row but there is nothing added in the sheet can you please help? Thanks

Trouble Exporting Data from Clay to Google Sheets? Get Help! | Clay

12 comments

· Sorted by Oldest

Channeled
APP
·
·
There could be a few reasons why the Google Sheet isn't updating despite Clay showing that the row was added. Let's troubleshoot: 1. Check your Google Sheets account permissions: Ensure the account you're using has write access to the sheet. 2. Verify the Google Spreadsheet URL: Make sure you've pasted the correct URL for the sheet you want to update. 3. Review your column mapping: Confirm that you've correctly mapped the Clay table columns to the Google Sheet columns. 4. Check run settings: Ensure auto-update is enabled for new rows in your Clay table. If these steps don't resolve the issue, you may need further assistance. Please request human support by clicking on "Talk to a person" for a more in-depth investigation of your specific setup.
Sources: Google Sheets integration overview | Documentation | Clay University Google Sheets [Clay 101] - Clay University
Brayan
·
·
https://app.clay.com/workspaces/286951/workbooks/wb_dyutFcgb77Xg/tables/t_RfP6GjbaKmJV/views/gv_JCcPFZmZtBpp
Brayan
·
·
Any updates? thanks
Brayan
·
·
Hello can you help ,e?
Bo (.
·
·
Hey Brayan - I replied in the other thread. Sorry for the delay, glad we got it working!!! :)
Brayan
·
·
Hey Friend, how are you ? Hey can you help try to get the personal emails using Apollo ? I added the enrichment but it only comes up with business emails and I’m trying to get the personal emails
Bo (.
·
·
Hey,
To get personal emails using Apollo, you'll need to use a custom HTTP API since Apollo doesn't expose personal emails through their regular enrichment.
Here's the Apollo.io People Match API configuration for the Clay HTTP API editor: Apollo.io People Match API ** Method: POST ** Endpoint: https://api.apollo.io/api/v1/people/match ** Query Parameters: first_name: firstname last_name: lastname organization_name: orgname domain: domain.com linkedin_url: liurl reveal_personal_emails: true reveal_phone_number: false ** Headers: Content-Type: application/json accept: application/json x-api-key: YOUR_API_KEY ** *Body: {} (Empty JSON object as parameters are passed in the URL) Remember to replace "YOUR_API_KEY" with your actual Apollo.io API key. This will search for the person using their details and specifically request personal emails.
Let me know if you need anything else!
Brayan
·
·
Can you help me set it up?
George D.
·
·
Hey Brayan - have you gone through the instructions above? Let us know if there's something specifically that you're running into and we can help get you unblocked! If you're looking for someone who may be able to build tables for you, you may want to check out our list of experts! clay.com/experts.
Brayan
·
·
Hi Clay team can you please check what error do I have? I did what you told me to however when I run the column it shows error
Loading attachments
Stefano
·
·
Hey, thanks for reaching out! I replied in the other thread, so I’ll close this one.
(1 kB)
P.S. Next time, please try to keep your request in one message. Thanks!
Channeled
APP
·
·

Channeled
APP
·
·
There could be a few reasons why the Google Sheet isn't updating despite Clay showing that the row was added. Let's troubleshoot: 1. Check your Google Sheets account permissions: Ensure the account you're using has write access to the sheet. 2. Verify the Google Spreadsheet URL: Make sure you've pasted the correct URL for the sheet you want to update. 3. Review your column mapping: Confirm that you've correctly mapped the Clay table columns to the Google Sheet columns. 4. Check run settings: Ensure auto-update is enabled for new rows in your Clay table. If these steps don't resolve the issue, you may need further assistance. Please request human support by clicking on "Talk to a person" for a more in-depth investigation of your specific setup.
Sources: Google Sheets integration overview | Documentation | Clay University Google Sheets [Clay 101] - Clay University
Brayan
·
·
https://app.clay.com/workspaces/286951/workbooks/wb_dyutFcgb77Xg/tables/t_RfP6GjbaKmJV/views/gv_JCcPFZmZtBpp
Brayan
·
·
Any updates? thanks
Brayan
·
·
Hello can you help ,e?
Bo (.
·
·
Hey Brayan - I replied in the other thread. Sorry for the delay, glad we got it working!!! :)
Brayan
·
·
Hey Friend, how are you ? Hey can you help try to get the personal emails using Apollo ? I added the enrichment but it only comes up with business emails and I’m trying to get the personal emails
Bo (.
·
·
Hey,
To get personal emails using Apollo, you'll need to use a custom HTTP API since Apollo doesn't expose personal emails through their regular enrichment.
Here's the Apollo.io People Match API configuration for the Clay HTTP API editor: Apollo.io People Match API ** Method: POST ** Endpoint: https://api.apollo.io/api/v1/people/match ** Query Parameters: first_name: firstname last_name: lastname organization_name: orgname domain: domain.com linkedin_url: liurl reveal_personal_emails: true reveal_phone_number: false ** Headers: Content-Type: application/json accept: application/json x-api-key: YOUR_API_KEY ** *Body: {} (Empty JSON object as parameters are passed in the URL) Remember to replace "YOUR_API_KEY" with your actual Apollo.io API key. This will search for the person using their details and specifically request personal emails.
Let me know if you need anything else!
Brayan
·
·
Can you help me set it up?
George D.
·
·
Hey Brayan - have you gone through the instructions above? Let us know if there's something specifically that you're running into and we can help get you unblocked! If you're looking for someone who may be able to build tables for you, you may want to check out our list of experts! clay.com/experts.
Brayan
·
·
Hi Clay team can you please check what error do I have? I did what you told me to however when I run the column it shows error
Loading attachments
Stefano
·
·
Hey, thanks for reaching out! I replied in the other thread, so I’ll close this one.
(1 kB)
P.S. Next time, please try to keep your request in one message. Thanks!
Channeled
APP
·
·