About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

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

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

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

Smartsheet error: There was no data available to create or update a row in Smartsheet

  • 9 January 2024
  • 5 replies
  • 41 views
J
Userlevel 1

Hi Everyone

I am new to zapier and trying to test my first basic zap, however I keep getting a fault. 

Can anyone help me to overcome a troubleshooting error I keep getting, please? I want to be able to have a basic zap that is bi-directional and allows for adds, updates and deletion of rows when interacting between Google Sheets and Smartsheet. The data is coming into the Google Sheet from a app I made. I want the data inputted onto google sheet to flow into, and populate, a specific smartsheet table. That is all I need.

I have provided a screenshot where the error keep appearing. Furthermore, do I have to input test data into zapier or can zapier check the connection between Google SHeets and Smartsheet via back-end protocols?

 

Please see attached screenshot

Thank you - John

1 Attachment
This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

5 replies

Troy Tessalone
Userlevel 7
Badge +14

Hi @johnnipearson 

Zaps aren’t meant for 2-way data syncs for the same data:

https://zapier.com/help/create/basics/does-zapier-support-two-way-syncing


We would need to see detailed screenshots with how your Zap step 2 is configured in the ‘Action’ section.

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Userlevel 1

Hi Troy

Thanks for the quick response back to me. Its a big help.

Oh, ok. I didnt know that. Is it possible to sent up another zap in the other direction in this case?

Please see ACTION screenshot.

1 Attachment
Troy Tessalone
Userlevel 7
Badge +14

@johnnipearson 

Make sure to read this help article about syncing via Zaps as you don’t want to create an infinite loop:

https://zapier.com/help/create/basics/does-zapier-support-two-way-syncing

 

Looks like you need to map data between Zap steps.

Help: https://zapier.com/help/create/basics/set-up-your-zap-action

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
J
Userlevel 1

Thanks for that Troy. I will keep to single flows in that case and do some work arounds. However, I am still even struggling to get the single flow working. All the column headers are the same in both smartsheet and google sheets though the process keeps faulting. Can you help me diagnose whats going on here please? I would really appreciate your assistance to work this out so i can understand what I am doing wrong.

 

I have add more photos of what I am seeing

 

Thank you - John

2 Attachments
Troy Tessalone
Userlevel 7
Badge +14

Hi @johnnipearson 

This looks to be your related topic:

 

⚡ Troy Tessalone - AutomationAce.com | Premier Certified Zapier Expert | #1 Zapier Community Contributor
Terms & Conditions