Skip to main content
Best answer

Zapier had trouble retrieving custom fields from Google Sheets again !


 

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 by DanversBest answer by Danvers

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 🙂

 

 

View original
Did this topic help you find an answer to your question?
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

  • Author
  • Beginner
  • 1 reply
  • April 16, 2020

One more precision.

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

 

 


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • Answer
  • April 24, 2020

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 🙂

 

 


  • Beginner
  • 2 replies
  • May 4, 2020

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.


Danvers
Forum|alt.badge.img+12
  • Zapier Staff
  • 3731 replies
  • May 7, 2020

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!


  • Beginner
  • 2 replies
  • May 7, 2020

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

 


  • New
  • 1 reply
  • May 21, 2020

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?


Oscar wrote:

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.


  • New
  • 1 reply
  • May 21, 2020

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


andywingrave
Forum|alt.badge.img+9
  • Zapier Expert
  • 854 replies
  • May 21, 2020