Best answer

Zapier had trouble retrieving custom fields from Google Sheets again !


Userlevel 1

 

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 ?

 

icon

Best answer by Danvers 24 April 2020, 15:00

View original

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

10 replies

Userlevel 1

One more precision.

It works when i retreive manually the Spreadshit with the same id.

 

 

Userlevel 7
Badge +12

Hi @Ouilok!

 

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!

  1. 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)
  2. Add any information into the fields that you need
  3. 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 🙂

 

 

Userlevel 1

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.

Userlevel 7
Badge +12

Hi @Hung I've escalated your post to the Support team and I sent you an email to get some more information. Please could you reply to that email and someone will be touch via email to help you with it as soon as possible. Thanks!

Userlevel 1

Thank you @Danvers I just replied the email you sent me :)

 

Userlevel 1

Hey @Danvers I’m having the same issue but I am not using a custom sheet ID. I am only trying to add a new row to an existing sheet: https://share.getcloudapp.com/NQuDG78Y

It’s a fairly straight forward request. What am I missing here?

Hey @Danvers I’m having the same issue but I am not using a custom sheet ID. I am only trying to add a new row to an existing sheet: https://share.getcloudapp.com/NQuDG78Y

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

Userlevel 7
Badge +9

Hey  - There’s an update on this issue in this thread.

 

https://community.zapier.com/ask-the-community-3/connecting-to-google-drive-sheets-the-app-returned-shared-drive-not-found-my-google-drive-2454?postid=9359

 

Looks like a bug, sadly