Hi all,
I would like to retrieve a specific Google sheet. Its name is stored on a Airtable Field….
I have the following message “Zapier had trouble retrieving custom fields from Google Sheets”.
What can i do ?
Best answer
Zapier had trouble retrieving custom fields from Google Sheets again !
- Beginner
- 1 reply
Best answer by DanversBest answer by Danvers
Hi
If you use a Custom Value for the Worksheet or Workbook in a Google Sheets step, you’ll see the “Zapier had trouble retrieving custom fields from Google Sheets” error. This is a limitation of the Google Sheets integration, sorry about that!
The good news is that there is a way to workaround this!
- In the editor, use the dropdown list to select the sheet that you want to use (or any sheet that has the same column headers)
- Add any information into the fields that you need
- Change the Worksheet/Workbook to your custom value
The Zap will give you an error message saying that there are extra fields in the Zap:
In this case, that’s ok - it’s the fields that we added before changing the sheet.
When you test the Zap and turn it on, it should work without an issue 🙂
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.
- Beginner
- 1 reply
One more precision.
It works when i retreive manually the Spreadshit with the same id.
+12- Zapier Staff
- 3731 replies
- Answer
Hi
If you use a Custom Value for the Worksheet or Workbook in a Google Sheets step, you’ll see the “Zapier had trouble retrieving custom fields from Google Sheets” error. This is a limitation of the Google Sheets integration, sorry about that!
The good news is that there is a way to workaround this!
- In the editor, use the dropdown list to select the sheet that you want to use (or any sheet that has the same column headers)
- Add any information into the fields that you need
- Change the Worksheet/Workbook to your custom value
The Zap will give you an error message saying that there are extra fields in the Zap:
In this case, that’s ok - it’s the fields that we added before changing the sheet.
When you test the Zap and turn it on, it should work without an issue 🙂
- Beginner
- 2 replies
I am facing the same problem. I tried and ignored the “Remove these extra fields” message, but after that, either test or real input didn’t work. Any other fix?
Thanks.
+12- Zapier Staff
- 3731 replies
Hi
- Beginner
- 2 replies
Thank you
1 person likes this
Hey
It’s a fairly straight forward request. What am I missing here?
Oscar wrote:
Hey
It’s a fairly straight forward request. What am I missing here?
I’m having the exact same issue. And I’ve created zaps to Google Sheets tons of times without any issue… super frustrating.
https://prnt.sc/skwu0y
I’m facing the same issue, Yesterday it was working fine, But today is not. Please help.
Is there any changes from Zapier? Or I am missing something.
Hi there,
I have the same problem. I dont use custom value. I just want to add a new spreadsheet row when a new facebook lead came in. In the past it worked pretty well. I tried to follow the steps for the workaround but I have no option of custom values or something.
How I can I fix it not knowing what a custom value actually is and dont want to use it.
Thank you
+9- Zapier Expert
- 854 replies
Hey - There’s an update on this issue in this thread.
Looks like a bug, sadly
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.