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

  • 20 May 2021
  • 1 reply

Userlevel 1



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

Userlevel 7
Badge +9

Hi @97Dudley3003,


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