sanp conversion -> xero invoice -> xero bill

“Anytime a new row (custom query) is created in SQL Server, create spreadsheet row in Google Sheets, format my data in Formatter by Zapier, etc.”

created by Carien du Plessis

How Zapier works (57 sec)

How Zapier works (57 sec)

Try this Zap FREE for 14 days

Trusted at companies large and small

This Zap works in 9 steps …

4.5 minutes to set up
Get back 1.2 hrs /week
41 people use this app pairing

This Zap uses the following 4 apps

SQL Server
SQL server (or MS SQL) is a top of the line database geared for the cloud
Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Formatter by Zapier
Data isn't always in the format you need. Perhaps a date is in International format, but your app needs it in American format. Or maybe you need to Title Case a subject, truncate text for a Tweet, or turn Markdown text into HTML for your blog. Zapier's Formatter tool can help.
Xero
Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

More ways to use these popular apps!

Check out all the other ways you can connect SQL Server and Google Sheets.