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.

We have a Zap that pulls from a Ninja Forms web submission. The zap steps are as follows:

  1. Ninja Form submission
  2. Create Spreadsheet Row
  3. Filter Conditions - checks if File Upload exists on form submission
    1. If yes, continue
    2. If no, stop zap
  4. Upload File - uploads file from form submission to a specified Google Drive Folder and renames it based on two text fields in the form submission
  5. Update Spreadsheet Row - updates the last row in the spreadsheet with all the form submission data and includes the Google Drive Alternate Link in a File Upload column

This has all worked up until just recently. However, the last step “update spreadsheet row” no longer brings the Alternate Link from the file uploaded to the Google Drive Folder into the appropriate cell on the Google Sheet row

When I retest all the steps in the Zap it passes and shows URL in the test (screenshot attached), but it never shows up in the actual Google Sheet cell.

 

Hi ​@Dietz Group 

Help us have more info by posting these screenshots:

  • how your Zap step is configured in the CONFIGURE tab while in EDIT mode with the field mappings visible
  • DATA IN/OUT from your Zap Runs history details for the steps: https://zapier.com/app/history/

Here is the history of the data in/out showing that it still has the Alternate Link in the step. Which step are you asking to see in the configuration of?

 

​@Dietz Group 

Need to see screenshots of the DATA IN/OUT for the Zap steps where you are having the issue with the file link, so probably 4 and 5.

 

 

​@Dietz Group 

For Step 5, from the screenshots it’s unclear how the Row field is configured.

From the Zap Run DATA IN/OUT, you should be able to see which was configured to be updated and which row was returned in the DATA OUT to help you troubleshoot in GSheets.

Sorry, I don’t completely understand what you are asking for when you say Zap Run DATA IN/OUT. The configuration of Step of is to update the row. Each field from the last row has been re-entered with the addition of adding in the Drawing Files (Alternate Link) from Google Drive. It has always just replaced the content and add the link.

 

​@Dietz Group 

For a Zap Run (https://zapier.com/app/history/), when you click on a Zap step, there are 3 tabs:

  • Setup
  • Configure
  • Run Details
    • Within Run details, there are tabs for:
      • DATA IN
      • DATA OUT
      • TROUBLESHOOTING
      • LOGS

 

You can use the Zap Run history details to see the DATA IN/OUT for each step to help you trace the data flow between Zap steps to help you troubleshoot.

e.g. See the exact GSheet Row that was created/updated and with what values for which columns.

 

 

Thank you for that explanation. In step 5, I know see a yellow explanation point in the Drawing Files field for the “Alternate Link”, but all that really does it tell me what I already know that this is no longer working, even though it was working just fine without any changes. I guess I’m going to have to find someone to actually support us here with this Zap in order to get a solution.

 

​@Dietz Group 

Directory of Certified Zapier Experts: https://zapier.com/experts

 

In the example screenshot you provided, the Zap Run was Filtered in Zap step 3, so Zap steps 4-5 never ran.

 

Terms & Conditions