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 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

Google Sheets add update record to SQL server

  • 2 June 2023
  • 4 replies
  • 72 views
aruza88
Userlevel 1

hallo, i have tried using template google sheet to sql, how to add update record in google sheets to sql? please help

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

Danvers
Userlevel 7
Badge +12

Hi @aruza88, welcome to the community!

So we can best help you, could you please describe what you’re trying to do in more detail? Could you share a link to the Zap template you’re using? And could you explain what you would like to happen eg when a new row is added to Google Sheets, add the information in the row to SQL.  If you’re stuck on a specific part of the Zap, or are seeing an error message, could you share a screenshot of that step in the Zap editor? Don’t forget to remove or obscure any personal or private information in any screenshot you share in the community (eg full name, email address, etc).

 

It sounds like you’re pretty new to Zapier, so I recommend looking at some of these resources, which are helpful for Zapier beginners:

Zapier Learn customer onboarding course - some lessons that walk you through the fundamentals of Zapier

Send data between steps by mapping fields - a help guide on how to setup Zap steps to send information between apps. 

 

​I hope that helps, please let us know if you have any questions!

aruza88
Userlevel 1

Sorry, i mean, integrate google sheet update record to sql server,in zapier  first step i hv tried create google sheet trigger event add and update record,step two second i create sql server find record and step 3 i create update record to sql. I think i hv mistake action in step 2 or 3. I little confuse. How step by step create action update to sql

aruza88
Userlevel 1

Please help flow integrate update record google sheet to sql server

2 Attachments
SamB
Rank
Userlevel 7
Badge +11

Thanks for sharing those screenshots and additional details here, @aruza88! 

It seems like you’re wanting to replicate updates that happen in Google Sheets in your SQL Server but it’s not it’s not updating the the row in SQL Server as expected. Am I understanding that correctly? 

If so, it looks like most of the select fields from the Google Sheets trigger don’t have any values present so nothing will be updated in the row on SQL Server when testing:
a7e5422509aa602652403329f9909b88.png

It also seems that the TradeID is being selected from the Google Sheets trigger, rather than taking the value from the Find Row action, so it might not be updating the same row that is found by the Find Row action. In which case you may want to tweak the Row field on that Update Row action slightly so that it’s referencing the tradeID for row that was found by the previous Find Row (SQL Server) action:
0a42d204a4e483164931f3a05e8b3d05.png
That should ensure that the Zap will update the same row that is found by the Find Row action. That is assuming the tradeID is unique to that specific row. If it’s not then you’d need to change the Row and ID Column fields to reference a more unique value for the row.

Can you give that a try and confirm whether that fixes things here? 

And if I’ve misunderstood the issue here, just let me know and we’ll go from there! 🙂

Terms & Conditions