Skip to main content

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Learning Resources
All of our best learning resources can be found here.

Featured Articles Show & Tell Zapier's products AI Hub Zapier Tools Hub

Share your knowledge
Give back to the Community by sharing your automation wins and helping to answer questions.

Share your success See unanswered questions User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

I have a zap created that sends data from a Ninja Form to a Google Drive folder and Google Sheet.

 

There is a “non-required’ file upload field on the Ninja Form. If the user uploads a file to the Ninja Form, the file is sent to a Google Drive folder.

 

All data from the Ninja Form is sent to the google sheet with the exception of the file upload field. I have that this mapped to the “Alternate Link” from the Google Drive.

 

If the user uploads a file to the Ninja Form, everything works correctly. However, if they do not upload a file to the Ninja Form, then no data at all is sent to the Google Sheet. I see an error in the zap history…

“Required field "file" (file) is missing.” 

“This Google Sheets step didn‘t run because it depended on a previous step or filter that wasn‘t successful.”
 

How do I get the zap to accept that someone may not upload a file and still send the remaining data onto the Google Sheet?

Hi @Dietz Group 

Use this formatter: https://zapier.com/help/create/format/set-default-values-for-blank-fields-in-zaps

What it does essentially is when your file field has no data (user didn’t add a file) you can specify a default value for this, which will pass over when there is no data.

Hi @Dietz Group

Alternatively you can try these Zap steps.

  1. Trigger: Ninja Forms - New Form Submission
  2. Action: GSheets - Create Row
  3. Action: Filter (check if file exists)
  4. Action: GDrive - Upload File
  5. Action: GSheets - Update Row (map Row ID # from Step 2)

@Troy Tessalone that’s perfect. Thanks for the answer!

Terms & Conditions