Google Sheets + Sage Accounting
Create Sage Accounting customers from new Google Sheets spreadsheet rows
Prevent duplication of data entry when New Contacts are created in Google Sheets. When new contacts are created in Google Sheets, the new spreadSheet row trigger event automatically invokes the create customer action in Sage Accounting. This results in the contact being created in your Sage Accounting business.
Prevent duplication of data entry when New Contacts are created in Google Sheets. When new contacts are created in Google Sheets, the new spreadSheet row trigger event automatically invokes the create customer action in Sage Accounting. This results in the contact being created in your Sage Accounting business.
- When this happens...
New Spreadsheet RowTriggered when a new row is added to the bottom of a spreadsheet.
TriggerInstantThis event starts a Zap instantly. - automatically do this!
Create CustomerCreates a new customer.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.TitleRequired
Spreadsheet to Copy
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
New Purchase Invoice
Triggers when a new purchase invoice is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Customer
Triggers when an existing customer is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Invoice
Triggers when a new sales invoice is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Service
Triggers when a new service is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Contact Payment
Triggers when an existing contact payment is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Purchase Invoice
Triggers when an existing purchase invoice is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Sales Quote
Triggers when a sales Quote is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Stock Item
Triggers when a stock item is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCreate Purchase Invoice
Creates a new purchase invoice.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
Notes
Credit Limit
Credit Term Days
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DateRequired
Invoice Number Prefix
Invoice Number
Reference
Notes
Terms And Conditions
Sent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Contact ReferenceRequired
Payment ReferenceRequired
Payment DateRequired
Total Payment AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Update Purchase Invoice
Triggers when an existing purchase invoice is updated.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Date
Quote Number Prefix
Quote Number
Reference
Notes
Terms And Conditions
Sent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter by Contact Name or Reference
Filter by Updated or Created Since the Given Date
Filter by From Date
Filter by To Date
ActionThis is an event a Zap performs.SearchFind existing data in your appBusiness Name or Reference to search for the Contact GUIDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice Number or ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appService Code or DescriptionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appFilter by Contact Name or Reference
Filter by Updated or Created Since the Given Date
Filter by From Date
Filter by To Date
Contact NameRequired
Contact ReferenceRequired
Payment ReferenceRequired
Payment DateRequired
Total Payment AmountRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundBusiness Name or Reference to search for the Contact GUIDRequired
Business NameRequired
Notes
Credit Limit
Credit Term Days
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundInvoice Number or ReferenceRequired
DateRequired
Invoice Number Prefix
Reference
Notes
Terms And Conditions
Sent
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundService Code or DescriptionRequired
DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
SpreadsheetRequired
WorksheetRequired
Trigger Column
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
RowRequired
Background Color
Text Color
Text Bold
Text Italic
Text Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Lookup ColumnRequired
Lookup ValueRequired
Supporting Lookup Column
Supporting Lookup Value
Bottom-Up
Row Count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
ColumnsRequired
Row CountRequired
First Row
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNew Contact Payment
Triggers when a new contact payment is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Customer
Triggers when a new customer is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Product
Triggers when a new product is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Sales Quote
Triggers when a new sales Quote is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Stock Item
Triggers when a new stock item is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Product
Triggers when a product is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Sales Invoice
Triggers when a sales invoice is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planUpdated Service
Triggers when a service is updated.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planContact NameRequired
Contact ReferenceRequired
Payment ReferenceRequired
Payment DateRequired
Total Payment AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Business NameRequired
Notes
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Create Sales Quote
Creates a new sales Quote.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Date
Invoice Number Prefix
Invoice Number
Reference
Notes
Terms And Conditions
Sent
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Description
Item Code
Notes
Active
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
HTTP MethodRequired
URLRequired
Query String Parameters
Headers
Additional Request Headers
Body
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appProduct Code or DescriptionRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appQuote Number or ReferenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appNameRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice ReferenceRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundProduct Code or DescriptionRequired
DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundQuote Number or ReferenceRequired
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundNameRequired
DescriptionRequired
Item Code
Notes
Active
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is found
About Google Sheets
Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.
Related categories
Similar apps
Zapier Tables
Databases, Spreadsheets, Zapier
Zoho Creator
App Builder, Zoho
Smartsheet
SpreadsheetsAbout Sage Accounting
Award winning accounting from the leader in financial accounting software. Manage invoicing, cash flow, tax, payments and more from any device through the cloud.
Related categories
Related Zap Templates
- Create multiple rows in Google Sheets for new Sage Accounting customers
- Create sales invoices in Sage Accounts from new spreadsheet rows in Google Sheets
- Log new Sage Accounting customers in Google Sheets
- Add newly-created Sage Accounting invoices to Google Sheets
- Create multiple rows in Google Sheets for new purchase invoices in Sage Accounting