Skip to main content
Best answer

Zapier had trouble retrieving custom fields from Google Sheets?

  • April 8, 2020
  • 1 reply
  • 307 views

Hi all,

 

I'm creating a Zap that inputs city-specific newsletter signups from my website into the relevant city’s mailing list, hosted as Google Sheets files on Google Drive.

Having used ‘Find a File in Google Drive’ based on the city value submitted on the form, I cannot get Zapier to then ‘Create a google sheets spreadsheet row’ in the previously identified file.

 

I am receiving a ‘Zapier had trouble retrieving custom fields from Google Sheets’ error as shown on the screenshot below.

 

Any idea how I can get this to work - perhaps a different value is needed in the ‘Spreadsheet’ field?

 

 

 

 

Best answer by willtmpBest answer by willtmp

Whoops- as quickly as I asked, I found the answer.

 

For anyone else wondering: https://community.zapier.com/ask-the-community-3/create-a-google-sheets-worksheet-and-create-spreadsheet-row-s-726#post3203

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.

1 reply

  • Author
  • 1 reply
  • Answer
  • April 8, 2020

Whoops- as quickly as I asked, I found the answer.

 

For anyone else wondering: https://community.zapier.com/ask-the-community-3/create-a-google-sheets-worksheet-and-create-spreadsheet-row-s-726#post3203