Skip to main content
Question

Error when setting up Google Sheets step: Optional fields without a value

  • May 20, 2021
  • 1 reply
  • 235 views

Hi, 

 

I am trying to create a look up step in a zap and just before I get through to test the zap I get the below. However I have repeatedly selected “My Drive” as the location of the spreadsheet I want to use.

 

As a bit of background I’m going Step 1) platform containing source data Step 2) lookup step to find row in spreadsheet Step 3) update relevant cell in spreadsheet with data from source data platform

 

 

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

robschmidt
Forum|alt.badge.img+9
  • Zapier Solution Partner
  • May 20, 2021

Hi @97Dudley3003,

 

You should just be able to hit Test & Review and run a test. That’s an optional field, not mandatory.