Best answer

Zapier had trouble retrieving custom fields from Google Sheets?

  • 8 April 2020
  • 1 reply
  • 307 views

Userlevel 1

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?

 

 

 

 

icon

Best answer by willtmp 8 April 2020, 11:26

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.

1 reply

Userlevel 1

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