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.

Question

Updating Rows on google sheets to Knack

S

Hello, I am new to Zapier.

I have managed to set up the trigger successfully, and also the action to create a new record i Knack. As you can see here:

 

Therefore, after I do this i go to my google spreadsheet and i update the row from the bottom (just like it requires). I also check if Zapier has recognised this and according to this it does recognise the new rows: 

 

However, when I check Knack, nothing ever seems to update? I have tried refreshing it and a new record is never added. Why is this so? Am i missing a step to make this happen?

I have always been under the assumption that when I make this google sheets integration, anything that I ever edit on my google sheets will automatically be updated in Knack. Am i wrong? please correct me and care to explain if so.

 

Thanks for your help.

Did this topic help you find an answer to your question?
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

4 replies

Troy Tessalone
Forum|alt.badge.img+14

Hi @Sean M 

Please provide screenshots of how your Zap steps are configured, with the mapping of data points from step 1 to step 2.

Check your Zap Runs history for the DATA IN/OUT of each step: https://zapier.com/app/history/

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
S
  • Sean M
  • Author
  • New
  • 1 reply
  • March 3, 2021
Troy Tessalone wrote:

Hi @Sean M 

Please provide screenshots of how your Zap steps are configured, with the mapping of data points from step 1 to step 2.

Check your Zap Runs history for the DATA IN/OUT of each step: https://zapier.com/app/history/

Here are the proposed steps: 

 

However, I have tried to tweek this. Where it says Data in i noticed only the object key was changing. Therefore, I tried to edit it further:

 

Here now i realised I may need to physcially assign each field. However, now when i do this i get this error message:

App returned 400 and said {"errors":[{"field":"field_5","type":"unique","message":"Country must be unique. \"Thailand\" is already being used."},{"field":"field_4","type":"unique","message":"Continent must be unique. \"Asia\" is already being used."},{"fie

 

Inside knack I have tried to tick the box ‘must be unique’ and I have also tried to make the fields into aut increment

Troy Tessalone
Forum|alt.badge.img+14

@Sean M 

Appears the Knack settings don’t allow for new rows to use an existing Country, hence the “must be unique” error.

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Danvers
Forum|alt.badge.img+12
  • DanversZapier Staff
  • Zapier Staff
  • 3731 replies
  • May 4, 2021

Hi @Sean M 🙂

Did @Troy Tessalone’s reply help here? And were you able to find a way to work with the Country field in Knack? We’d love to know!

Terms & Conditions