Google Sheets + Sage Accounting
Update Google Sheets rows with new contact payments from Sage Accounting
Use this workflow to maintain an up-to-date record of financial transactions. When a new contact payment happens in Sage Accounting, it will update a corresponding row in a Google Sheets spreadsheet. This is perfect to keep your accounting and spreadsheets perfectly matched and minimizing manual data entry. It simplifies financial management and enhances accuracy in documentation.
Use this workflow to maintain an up-to-date record of financial transactions. When a new contact payment happens in Sage Accounting, it will update a corresponding row in a Google Sheets spreadsheet. This is perfect to keep your accounting and spreadsheets perfectly matched and minimizing manual data entry. It simplifies financial management and enhances accuracy in documentation.
- When this happens...
New Contact PaymentTriggers when a new contact payment is created.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Update Spreadsheet RowUpdate a row in a specific spreadsheet with optional formatting.
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
New Contact Payment
Triggers when a new contact payment is created.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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.Payment Reference
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.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
Additional request headers
Body
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
Reference
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 foundDrive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier 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.Drive
SpreadsheetRequired
WorksheetRequired
Frozen Rows Count
Frozen Columns Count
Sheet Position
Hide Sheet
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Source RangeRequired
Destination RangeRequired
Paste Type
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.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
Drive
SpreadsheetRequired
WorksheetRequired
Row(s)Required
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Validation TypeRequired
Input Message
Strict Validation
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
Bold
Italic
Strikethrough
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Stop on errorRequired
HTTP MethodRequired
URLRequired
Query string parameters
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
ColumnsRequired
Row countRequired
Output format
First row
ActionThis is an event a Zap performs.SearchFind existing data in your appSpreadsheet IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
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 ZapPollingZapier checks for new data every 15 min on the Free planUpdated Contact
Triggers when an existing contact is updated.
Try ItTriggerThis is the start of your ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier 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 ZapPollingZapier checks for new data every 15 min on the Free planPayment 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.Create 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
Reference
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.Enter the Nominal Code or Ledger Account Diplay Name to return the Ledger Account IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appInvoice 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 foundNo 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 ZapPollingZapier checks for new data every 15 min on the Free planDrive
SpreadsheetRequired
WorksheetRequired
Use Timezone set up on the spreadsheet to format date values?
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
Cell RangeRequired
Condition TypeRequired
Background Color
Text Color
Bold Text
Italic Text
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 Worksheet Destination
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
TitleRequired
Overwrite existing worksheet with the same title
Headers
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Confirm DeletionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Format TypeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.SpreadsheetRequired
WorksheetRequired
New Sheet NameRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
SpreadsheetRequired
WorksheetRequired
Cell RangeRequired
Sort by ColumnRequired
Sort OrderRequired
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
Search from last row
Row count
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
A1 RangeRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
SpreadsheetRequired
WorksheetRequired
Row IDRequired
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
Search from last row
Row count
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
Search from last row
Row count
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
Related categories
About Sage Accounting
Related categories
Related Zap Templates
- 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 Sage Accounting customers from new Google Sheets spreadsheet rows
- Create multiple rows in Google Sheets for new Sage Accounting customers