Google Sheets + Xero
Create Xero invoices from new Google Sheets rows
Set up this Zap to streamline your invoicing workflows. Once this integration is active, simply add data to a new row in a specified Google Sheets spreadsheet and a Xero invoice will be generated automatically. Manage your invoices without ever leaving Google Sheets!
Set up this Zap to streamline your invoicing workflows. Once this integration is active, simply add data to a new row in a specified Google Sheets spreadsheet and a Xero invoice will be generated automatically. Manage your invoices without ever leaving Google Sheets!
- When this happens...
TriggerScheduledZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Sales InvoiceCreates a new sales invoice (Accounts Receivable).
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
OrganizationRequired
Days OverdueRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Project State
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Quote Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Status
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationRequired
Status
Change
Contact
Trigger Preference
Copy
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.OrganizationRequired
InvoiceRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Item CodeRequired
NameRequired
Description
Is SoldRequired
Sales Unit Price
Sales Account
Sales Tax Type
Is PurchasedRequired
Purchase Description
Purchase Unit Price
Purchase Account
Purchase Tax Type
Is TrackedRequired
Inventory Asset Account
Cost of Goods Sold Account
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Transaction TypeRequired
ContactRequired
Bank AccountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Contact NameRequired
Account Number
Contact Requirements
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Secondary Person - First Name
Secondary Person - Last Name
Secondary Person - Email
Include secondary person in emails sent to contact?
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Address Type Of
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Tax Number
Bank Account Number
Groups
Contact Number
Company Number
Payment Terms - Invoice Due (days)
Payment Terms - Type for Sales Invoices
Payment Terms - Bill Due (days)
Payment Terms - Type for Purchase Invoices
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
TypeRequired
ContactRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item CodeRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Contact NameRequired
Email Address
Contact Account Number
Primary Person - First Name
Primary Person - Last Name
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Contact Address Type
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Contact Tax Number
Bank Account Number
Contact Number
Status
Date
Due Date
Currency
Url
Attachment
Branding Theme
Number
Reference
Sent To Contact
Line Items Type
Item Code
Description
QuantityRequired
Unit Price
Discount %
Discount Amount
Account
Tax Rate
Tracking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
ContactRequired
Project NameRequired
Deadline for the project
Project Estimate
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
ContactRequired
Repeated Invoice Schedule
Invoice Creation: Frequency TypeRequired
Invoice Creation: Frequency (Period)Required
Due Date Type: Payment TermsRequired
Set Due Dates (Days)Required
Start Date: Required
End Date
StatusRequired
Currency
Branding Theme
Reference
Mark as approved for sending?
Email a copy to Sender?
Include PDF
Line Amount Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Info
OrganizationRequired
Invoice IdRequired
Contact
Status
Date
Due Date
Expected Payment Date
Reference
Branding Theme
Url
Currency
Sent To Contact
Attachments
Invoice Number
Line Amount Types
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.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.OrganizationRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganizationRequired
Invoice IDRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganizationRequired
Search ByRequired
Contact NameRequired
Account Number
Contact Requirements
Primary Person - First Name
Primary Person - Last Name
Primary Person - Email
Secondary Person - First Name
Secondary Person - Last Name
Secondary Person - Email
Include secondary person in emails sent to contact?
Phone - Country Code
Phone - Area Code
Phone Number
Fax - Country Code
Fax - Area Code
Fax - Number
Mobile - Country Code
Mobile - Area Code
Mobile - Number
Direct Dial - Country Code
Direct Dial - Area Code
Direct Dial - Number
Address Type Of
Address - Attention
Address - Line 1
Address - Line 2
Address - City/Town
Address - State/Region
Address - Postal/Zip Code
Address - Country
Tax Number
Bank Account Number
Groups
Contact Number
Company Number
Payment Terms - Invoice Due (days)
Payment Terms - Type for Sales Invoices
Payment Terms - Bill Due (days)
Payment Terms - Type for Purchase Invoices
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
OrganizationRequired
Status
Type
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Payment Type
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Purchase Order Status
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Payment Type
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrganizationRequired
Invoice IDRequired
NoteRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Credit Note IDRequired
Invoice IDRequired
AmountRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
From AccountRequired
To AccountRequired
AmountRequired
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
ContactRequired
Date
Expiry
Quote Number
Reference
Theme
Title
Summary
Currency
Amounts Are
Terms
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Invoice IDRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Contact NameRequired
Email Address
Status
Date
Due Date
Currency
Url
Attachment
Branding Theme
Reference
Line Items Type
Item Code
Description
QuantityRequired
Unit Price
Account
Tax Rate
Tracking
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Document Type
Document ID or NumberRequired
Paid ToRequired
Date
Currency Rate
AmountRequired
Reference
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Contact (supplier)Required
Date
Delivery Date
Order Number
Reference
Theme
Currency
Tax Type
Delivery Address
Attention
Telephone
Delivery Instructions
Attachments
Purchase Order Status
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Purchase OrderRequired
Contact
Update Method for Line Items
Date
Delivery Date
Line Amount Types
Purchase Order Number
Reference
Branding Theme
Currency
Status
Sent to Contact
Delivery Address
Attention To
Telephone
Delivery Instructions
Expected Arrival Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Resource typeRequired
FileRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.OrganizationRequired
Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganizationRequired
Search ByRequired
Include Online Invoice URL
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganizationRequired
Search ByRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appOrganizationRequired
Search ByRequired
Mark Item as a Sales Item?
Mark Item as a Purchase Item?
Item Name
Item CodeRequired
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 Xero
Related categories
Related Zap Templates
- Create Xero invoices for new Stripe payments
- Create Xero invoices for new WooCommerce orders
- Create Xero invoices for new Shopify paid orders
- Send Gmail messages when new payments are received in Xero
- Create Xero Invoices for your Ticket Tailor orders
- Add new Mailchimp subscribers from new contacts in Xero
- Get a summary of new payments from Xero delivered to you via Slack daily, weekly or monthly
- Get Slack alert messages for new Xero invoices
- Create Xero sales invoices for new eBay orders
- Save new Xero invoices to Google Sheets rows
- Create Xero invoices when new Pipedrive deals reach certain stages
- Create Xero invoices from new Jotform entries
- Send Slack channel messages for new payments in Xero
- Create Xero invoices from new Skedda bookings
- Create Xero sales invoices for new Stripe invoices
- Create Xero invoices from new Salesforce custom objects
- Create items in monday.com for new sales invoices in Xero
- Create or update Xero contacts for new Stripe customers
- Add new Keap Max Classic invoices to Xero as invoices
- Send Xero invoices when new terms are received in Survey Booker
- Get a scheduled summary of new payments from Xero delivered to Gmail
- Create Xero sales invoices for updated HubSpot deal stages
- Create new Xero invoices for new PayPal sales
- Update Xero contacts from new changes in Pixie
- Add rows in Google Sheets from new Xero payments
- Add new Xero contacts to ActiveCampaign
- Send new Ecwid orders to Xero (line item support)
- Add paid proposals from Better Proposals to Xero as invoices
- Create sales invoices in Xero and send by email for new Jotform submissions
- Create sales invoices in Xero for new or updated module entries in Zoho CRM
- Create sales invoices in Xero from new Teachworks invoices
- Get a digest of new Xero sales invoices sent to your Gmail on a daily, weekly, or monthly schedule
- Add new FareHarbor bookings to Xero as sales invoices
- Copy new posted invoices from Workbooks CRM to Xero
- Create contacs in Xero when new opportunities reach specified stages in Copper
- Create Xero invoices when Qwilr projects are accepted
- Create Xero sales invoices from newly approved documents in Zomentum
- Create bills in Xero for new Jotform submissions
- Create Zero sales invoices for new Uplisting bookings
- Create or update Xero contacts from new Jotform submissions
- Create Xero invoices for new Bigcommerce orders
- Create new Pipedrive deals from Xero quotes
- Relay Webhook messages posted to a web server as new Xero invoices
- Create Xero sales invoices from ShipStation orders
- Create new Xero payments from processed Parseur documents
- Send emails in Microsoft Outlook for new payments in Xero
- Create Xero invoices from new Gravity Forms entries
- Catch new webhooks and create or update contacts in Xero
- Add new Actionstep contacts to Xero
- Add invoices on Xero for new successful ChargeBee charges
- Create Xero contacts from new eBay orders
- Create sales invoices in Xero for new bookings in Lodgify
- Create new Xero invoices from parsed emails by Zapier
- Create Xero sales invoices for new Microsoft Excel table rows
- Create bills in Xero for new items in monday.com boards
- Update Xero contacts from new OnceHub bookings
- Add Giving Stories to Cart in B1G1 for paid Xero invoices
- Log new Xero bank transactions as Google Sheets rows
- Create Xero sales invoices for new or updated Hostaway reservations
- Finalize invoices in Booqable and create new sales invoices in Xero
- Add new Zoho Forms submissions to Xero as contacts
- Create Xero invoices for new Google Calendar events
- Generate Xero invoices from updated Webflow orders
- Create Airtable records from new sales invoices in Xero
- Import invoices into Xero from PDF or scanned documents
- Create new Xero sales invoices for won Proposify proposals
- Create or update Xero contacts when new ZenMaid contacts are added
- Create sales invoices in Xero for new purchases in Kajabi
- Create or update Xero contacts with new customers from Copilot CRM
- Generate Xero sales invoices when ZenMaid services are updated
- Create sales invoices in Xero for new fieldd invoices
- Create new Xero quote drafts from Gravity Forms submissions
- Add rows to Microsoft Excel for new sales invoices in Xero
- Add new Quaderno invoices to Xero as new invoices
- Create payments in Teachworks from new payments in Xero
- Create purchase orders in Xero for new bills, streamlining your accounting process
- Send sales invoices by email in Xero for new paid orders in Shopify
- Create Airtable records from new Xero payments
- Create quote drafts in Xero when cards are moved to a list in Trello
- Create bills in Xero for new responses in Google Forms spreadsheet
- Add new Xero contacts to Klaviyo list as profiles instantly
- Create new Notion items from new Xero bank transactions
- Send outbound emails for new Xero sales invoices with Email by Zapier
- A new invoice is created on Xero for new transactions on Braintree
- Create sales invoices in Xero for new product purchases in ThriveCart
- Create Airtable records for new Xero bank transactions
- Create items in monday.com for new quotes in Xero
- Create sales invoices in Xero for new Teachable transactions
- Upload new Xero sales invoices to a specific column in monday.com files
- Create Xero invoices from new items in Podio
- Create Xero invoices from new Zoho Books sales invoices
- Add new Typeform entries to Xero as bills
- Create sales invoices in Xero from new GoCanvas form submissions
- Create sales invoices in Xero for new payments in LearnWorlds
- Create Xero bills for new Square payments
- Add new Xero bills to Google Ads customer list as contacts
- Create payments in Xero for new bookings in Lodgify
- Create and email Xero sales invoices for new Airtable records
- Create orders in ShipStation from new payments in Xero
Related Zap Templates
- Create Xero invoices for new Stripe payments
- Send Gmail messages when new payments are received in Xero
- Get a summary of new payments from Xero delivered to you via Slack daily, weekly or monthly
- Save new Xero invoices to Google Sheets rows
- Send Slack channel messages for new payments in Xero
- Create Xero invoices from new Salesforce custom objects
- Add new Keap Max Classic invoices to Xero as invoices
- Create Xero sales invoices for updated HubSpot deal stages
- Add rows in Google Sheets from new Xero payments
- Add paid proposals from Better Proposals to Xero as invoices
- Create sales invoices in Xero from new Teachworks invoices
- Copy new posted invoices from Workbooks CRM to Xero
- Create Xero sales invoices from newly approved documents in Zomentum
- Create or update Xero contacts from new Jotform submissions
- Relay Webhook messages posted to a web server as new Xero invoices
- Send emails in Microsoft Outlook for new payments in Xero
- Add new Actionstep contacts to Xero
- Create sales invoices in Xero for new bookings in Lodgify
- Create bills in Xero for new items in monday.com boards
- Log new Xero bank transactions as Google Sheets rows
- Add new Zoho Forms submissions to Xero as contacts
- Create Airtable records from new sales invoices in Xero
- Create or update Xero contacts when new ZenMaid contacts are added
- Generate Xero sales invoices when ZenMaid services are updated
- Add rows to Microsoft Excel for new sales invoices in Xero
- Create purchase orders in Xero for new bills, streamlining your accounting process
- Create quote drafts in Xero when cards are moved to a list in Trello
- Create new Notion items from new Xero bank transactions
- Create sales invoices in Xero for new product purchases in ThriveCart
- Create sales invoices in Xero for new Teachable transactions
- Create Xero invoices from new Zoho Books sales invoices
- Create sales invoices in Xero for new payments in LearnWorlds
- Create payments in Xero for new bookings in Lodgify
- Create Xero invoices for new WooCommerce orders
- Create Xero Invoices for your Ticket Tailor orders
- Get Slack alert messages for new Xero invoices
- Create Xero invoices when new Pipedrive deals reach certain stages
- Create Xero invoices from new Skedda bookings
- Create items in monday.com for new sales invoices in Xero
- Send Xero invoices when new terms are received in Survey Booker
- Create new Xero invoices for new PayPal sales
- Add new Xero contacts to ActiveCampaign
- Create sales invoices in Xero and send by email for new Jotform submissions
- Get a digest of new Xero sales invoices sent to your Gmail on a daily, weekly, or monthly schedule
- Create contacs in Xero when new opportunities reach specified stages in Copper
- Create bills in Xero for new Jotform submissions
- Create Xero invoices for new Bigcommerce orders
- Create Xero sales invoices from ShipStation orders
- Create Xero invoices from new Gravity Forms entries
- Add invoices on Xero for new successful ChargeBee charges
- Create new Xero invoices from parsed emails by Zapier
- Update Xero contacts from new OnceHub bookings
- Create Xero sales invoices for new or updated Hostaway reservations
- Create Xero invoices for new Google Calendar events
- Import invoices into Xero from PDF or scanned documents
- Create sales invoices in Xero for new purchases in Kajabi
- Create sales invoices in Xero for new fieldd invoices
- Add new Quaderno invoices to Xero as new invoices
- Send sales invoices by email in Xero for new paid orders in Shopify
- Create bills in Xero for new responses in Google Forms spreadsheet
- Send outbound emails for new Xero sales invoices with Email by Zapier
- Create Airtable records for new Xero bank transactions
- Upload new Xero sales invoices to a specific column in monday.com files
- Add new Typeform entries to Xero as bills
- Create Xero bills for new Square payments
- Create and email Xero sales invoices for new Airtable records
- Create Xero invoices for new Shopify paid orders
- Add new Mailchimp subscribers from new contacts in Xero
- Create Xero sales invoices for new eBay orders
- Create Xero invoices from new Jotform entries
- Create Xero sales invoices for new Stripe invoices
- Create or update Xero contacts for new Stripe customers
- Get a scheduled summary of new payments from Xero delivered to Gmail
- Update Xero contacts from new changes in Pixie
- Send new Ecwid orders to Xero (line item support)
- Create sales invoices in Xero for new or updated module entries in Zoho CRM
- Add new FareHarbor bookings to Xero as sales invoices
- Create Xero invoices when Qwilr projects are accepted
- Create Zero sales invoices for new Uplisting bookings
- Create new Pipedrive deals from Xero quotes
- Create new Xero payments from processed Parseur documents
- Catch new webhooks and create or update contacts in Xero
- Create Xero contacts from new eBay orders
- Create Xero sales invoices for new Microsoft Excel table rows
- Add Giving Stories to Cart in B1G1 for paid Xero invoices
- Finalize invoices in Booqable and create new sales invoices in Xero
- Generate Xero invoices from updated Webflow orders
- Create new Xero sales invoices for won Proposify proposals
- Create or update Xero contacts with new customers from Copilot CRM
- Create new Xero quote drafts from Gravity Forms submissions
- Create payments in Teachworks from new payments in Xero
- Create Airtable records from new Xero payments
- Add new Xero contacts to Klaviyo list as profiles instantly
- A new invoice is created on Xero for new transactions on Braintree
- Create items in monday.com for new quotes in Xero
- Create Xero invoices from new items in Podio
- Create sales invoices in Xero from new GoCanvas form submissions
- Add new Xero bills to Google Ads customer list as contacts
- Create orders in ShipStation from new payments in Xero