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.

Hello All!

Quick summary of the issue is that the data is not being updated for all of the fields 


I am populating some date into a Google Sheet from Airtable. I’ve used the following layout.

 

For the Lookup field I’m using the primary field in Airtable. It is pulling in 3 different fields from Airtable and has been populating those perfectly if the Lookup is not found. If this Lookup field is modified it properly finds and updates that.

The issue is that the other 2 fields that it originally populated are not being updated if they are changed in Airtable. They are available to add to the Create section but I see nothing for the Update section.

Any clue if this is even possible?

Hi @KSAirtable 

For us to have more info…

  • post screenshots showing how your Zap steps are configured in EDIT mode so we can see the field mappings
  • outline a specific example for us to have more details about the issues

Hi @KSAirtable,

 

Just to advise, when posting a screenshot to the Community, it is essential to obscure any sensitive information within the screenshot for security purposes. Thank you. We're looking forward to troubleshooting your issue further.

Thanks, here are further details

 

Area in Green Updates when changed in Airtable. Area in Red is Created when new but does not update.
​​​​​

It removed these on the first Publish:

Hopefully this makes sense and thanks for the help!

Hi @KSAirtable,

It looks like there are Extra Fields on your Lookup Spreadsheet Row step. When the “Extra Fields” is present the Zap could run into some issues. I recommend clicking on the “Remove Extra Fields” button and republishing the Zap. You can learn more about that here: https://help.zapier.com/hc/en-us/articles/8495958376205-Why-is-there-a-section-called-Extra-Fields-on-my-Zap-action

ecd7614a6e357439980fb8932ccb6441.png
(view larger)

Kindly give it a try and let me know how it goes? I'll keep an eye out for your response!

Thanks for the response!

I’ve removed those, republished, and ran it again. It still does not update the full row. 

@KSAirtable 

For live Zap Runs, check your Zap Runs history details to see the DATA IN/OUT for each step to help you trace the data flow and troubleshoot.

Post screenshots of the Zap Runs DATA IN/OUT to give us more context about specific examples.

https://zapier.com/app/history/

Hi Troy,

 

The History shows only new fields found as I look through and nothing pertaining to updates. It’s as if Zapier can’t see updates beyond the Lookup field. This would make sense since Zapier never asks for all of the fields except in the Create section as I posted above.

I could probably post this data while redacting everything but I’m not sure how that would help since it’s only creating a new row and doesn’t have a history pertaining to updates since it can’t see them. No errors are in the History.

I have found a workaround to concatenate the data into the Lookup field then using Google Sheets to distribute the information as necessary. It just seems a long way to go about it. 

@KSAirtable 

If you are trying to do a find/create + update, then you may need to configure your Zap steps as follows…

 

NOTE: Airtable only returns fields that have values in order to keep the data payload as small as possible.

 

Screenshot shows a Zap with 2 steps configured like this, but you may need to add a Zap step 3.

  1. Trigger: Airtable - New or Updated Record
    1. This will trigger for NEW record AND for UPDATED records
  2. Action: GSheets - Lookup Row
    1. Configured to create new row if not found
  3. Action: GSheets - Update Row
    1. Map the ID/Row from Step 2
    2. Map the variables to column field from Step 1

 

Thanks for the reply!

With the free limitations of only 2 steps I can’t fully test this. I will ask my company to purchase an account so I can continue testing.

@KSAirtable 

You can test in the Zap EDIT mode, but you need a Zapier paid account to turn a Zap ON with 3+ steps.

@KSAirtable

If you are trying to do a find/create + update, then you may need to configure your Zap steps as follows…

 

NOTE: Airtable only returns fields that have values in order to keep the data payload as small as possible.

 

Screenshot shows a Zap with 2 steps configured like this, but you may need to add a Zap step 3.

  1. Trigger: Airtable - New or Updated Record
    1. This will trigger for NEW record AND for UPDATED records
  2. Action: GSheets - Lookup Row
    1. Configured to create new row if not found
  3. Action: GSheets - Update Row
    1. Map the ID/Row from Step 2
    2. Map the variables to column field from Step 1

 

Thanks so much for all of the help! I was able to add a 3rd Step which was exactly as you described above and it properly updates everything.

Reply


Terms & Conditions