Issues with Google Sheet Export Enrichment for EU Companies

Helena P. · 2025-01-08T15:01:17.952Z

Hello Clay Support team, I’d like to ask about the Google Sheet export enrichment. I have a table EU companies that already had a Google Sheet export, but it stoped working and it only reported errors or the time run out. So I removed the old column and created a new one. But for some reason I cannot map the columns as I did in the previous one. My google sheet file is shared for everyone who has the link and is alwo marked as an editor. Could you please advise? Here is the table:

Issues with Google Sheet Export Enrichment for EU Companies | Clay

Channeled
APP
·
·
👋 Hey there! Our support team has got your message - we'll be back in touch soon. If you haven't already, please include the URL of your table in this thread so that we can help you as quickly as possible!
Bruno R.
·
·
Hi Helena, thanks for reaching out. Taking a look at this now!
Bruno R.
·
·
Could you attempt to reconnect your google sheets account by following the directions in this guide? There seems to be an issue with the authentication of your credentials here: https://www.clay.com/university/guide/google-sheets-integration-overview Let me know if this resolves this issue and if I can help with anything else!
Helena P.
·
·
Hi Bruno, thank you. I will give it a try. 🙂
Helena P.
·
·
Hi Bruno, I followed the instructions from Action Lookup, Add, or Update Row section and the issue is that when I want to map the fields there is nothing to map.
Helena P.
·
·
Is it possible that it is like that because of filter used in the google sheets?
Bruno R.
·
·
Hi Helena, I went ahead recorded this video to show you how you can retrieve the individual column values associated with your table's sheets here: https://www.loom.com/share/9d17f24464884504a72b1f7ad6ec8cc8?sid=206a2045-7275-453a-a0c2-323c8bb7c435 Let me know if this makes sense and if I can help with anything else, this should resolve the issue with the upsert action.
Helena P.
·
·
Hi Bruno, thank you so much. I had done exactly the same as you did in the video since the noon but for some reason the Field mapping did not display for me.
Helena P.
·
·
Now it finally worked.
Bruno R.
·
·
Happy you were able to get this up and running!
Helena P.
·
·
it is still loading the look up fields tho.
Helena P.
·
·
Helena P.
·
·
It is loading pretty long.
Bruno R.
·
·
Hi Helena, were you able to run the integration? The loading time is due to Google Sheets' rate limits, which unfortunately means there's little we can do to improve it on our end. Let me know if you need further assistance!
Helena P.
·
·
No I still cannot map the fields. I got to the poinz where it let me to put in the ORG ids as a Lookup value, but after that it froze and I could not map anything. 😕

33 comments