Google Sheets + Holded
Create Holded sales invoices from new or updated rows in Google Sheets team drive
Streamline your invoice generation process with Google Sheets and Holded. When there is a new or updated row in your Google Sheets Team Drive, a sales invoice will be created in Holded right away. This workflow offers a simple, efficient method of managing your invoices, saving you valuable administration time and ensuring your bookkeeping stays consistent and up-to-date.
Streamline your invoice generation process with Google Sheets and Holded. When there is a new or updated row in your Google Sheets Team Drive, a sales invoice will be created in Holded right away. This workflow offers a simple, efficient method of managing your invoices, saving you valuable administration time and ensuring your bookkeeping stays consistent and up-to-date.
- When this happens...
New or Updated Spreadsheet Row (Team Drive)Triggers when a new row is added or an existing row is updated in a spreadsheet. Optimized for Team Drive.
TriggerPollingZapier checks for new data every 15 min on the Free plan - automatically do this!
Create Sales InvoiceCreates a sales invoice
ActionWriteCreate a new record or update an existing record in your app.
- Free forever for core features
- 14 day trial for premium features & apps
Dont Change Sheet Structure
Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planDont Change Sheet Structure
No 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.Drive
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 Contact
Triggers when a new contact is created
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 Sales Order
Triggers when a new sales order is created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact NameRequired
Contact Code
Contact Relationship
Contact type
Contact Email
Phone Number
Mobile Phone
Website
Address
City
Postal Code
Province
Country
IBAN
Swift
Sepa Reference
Note
Currency
Language
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Sales Funnel
Contact
Deal Name
Deal Value
Deal Potential
Due Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Name
Contact Name
Start
Location
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Bank
Contact
AmountRequired
Description
Date
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
DateRequired
Notes
Document Number
Name
Units
Subtotal
Discount
Tax Rate (%)
Taxes
Currency
Due Date
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
DateRequired
Notes
Sales Channel
Document Number
Name
Units
SKU
Service ID
Subtotal
Discount (%)
Tax Rate (%)
Taxes
Shipping Cost
Shipping Tax
Currency
Due Date
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country Code
Description
Notes
Receipt DateRequired
Name
Units
SKU
Service ID
Subtotal
Discount (%)
Tax (%)
Taxes
Shipping Cost
Shipping Tax
Receipt Number
Currency
Due Date
Warehouse
Sales Channel
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IDRequired
Payment DateRequired
Payment AmountRequired
Treasury
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IDRequired
Recipient EmailRequired
SubjectRequired
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact Name
Contact Email
Contact Code
Contact ID
ActionThis is an event a Zap performs.SearchFind existing data in your app
Dont Change Sheet Structure
No Team Drive
SpreadsheetRequired
WorksheetRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Dont Change Sheet Structure
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 foundNew Deal
Triggers when a new CRM Deal is created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planNew 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 planNew Sales Receipt
Triggers when a new sales receipt has been created
Try ItTriggerThis is the start of your ZapPollingZapier checks for new data every 15 min on the Free planContact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
Notes
DateRequired
Name
Units
SKU
Subtotal
Discount (%)
Tax Rate (%)
Taxes
Document Number
Currency
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.First NameRequired
Last NameRequired
EmailRequired
Send Invite
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
Notes
Invoice DateRequired
Name
Units
SKU
Subtotal
Discount (%)
Tax Rate (%)
Taxes
Shipping Cost
Shipping Tax
Invoice Number
Currency
Due Date
Warehouse
Sales Channel
Numbering Series
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Product NameRequired
Description
Price
Tax (%)
Cost
Barcode
SKU
Weight (kg)
Stock
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
Document DateRequired
Notes
Warehouse
Sales Channel
Name
Units
SKU
Subtotal
Tax Rate (%)
Discount (%)
Taxes
Shipping Cost
Shipping Tax
Document Number
Currency
Due Date
Shipping Address
Shipping Postal Code
Shipping City
Shipping Province
Shipping Country
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact ID
Contact Code
Contact Name
Contact Email
Contact Address
Contact City
Contact Postal Code
Contact Province
Contact Country
Contact Country Code
Description
DateRequired
Notes
Warehouse
Name
Units
SKU
Subtotal
Tax Rate (%)
Discount (%)
Taxes
Shipping Cost
Shipping Tax
Document Number
Currency
Due Date
Shipping Address
Shipping Postal Code
Shipping City
Shipping Province
Shipping Country
Sales Channel
Tags
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IDRequired
Payment DateRequired
Payment AmountRequired
Treasury
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Document IDRequired
Recipient EmailRequired
SubjectRequired
MessageRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact IDRequired
Name
Contact Code
Trade Name
Email
Mobile Phone
Phone
IBAN
SWIFT
Sepa Reference
Sepa Date
Address
Citry
Postal Code
Province
Country
Country Code
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Contact NameRequired
Contact Email
Contact Code
Contact ID
Contact Relationship
Contact type
Phone Number
Mobile Phone
Website
Address
City
Postal Code
Province
Country
IBAN
Swift
Sepa Reference
Note
Currency
Language
Tags
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 Holded
Related categories
Related Zap Templates
- Create rows in Google Sheets for new Holded sales invoices
- Create Google Sheets rows for new Holded contacts
- Create Holded contacts from new Google Sheets rows
- Add new Holded purchase invoices to Google Sheets as rows
- Create Google Sheets rows for every new sales order in Holded
- Create multiple spreadsheet rows in Google Sheets for new contacts in Holded
- Create multiple rows in Google Sheets when new sales invoices occur in Holded
- Create new Holded contacts from new or updated rows in Google Sheets team drive
- Create Google Sheets rows for new Holded sales receipts
- Create multiple rows in Google Sheets for new purchase invoices in Holded
- Update Google Sheets rows when new sales invoices are created in Holded
- Create Holded contacts from new or updated Google Sheets rows
- Create sales orders in Holded from new rows in Google Sheets
- Create purchase invoices in Holded for new or updated rows in Google Sheets
- Create Holded sales invoices from new or updated Google Sheets rows
- Create new Holded quotes from updated rows in Google Sheets
- Create spreadsheets in Google Sheets for each new sales invoice in Holded
- Add new Holded deals to a Google Sheets row instantly
- Create new Holded deals from new Google Sheets rows
- Create quotes in Holded for new or updated rows in Google Sheets
- Create new Holded events from updated rows in Google Sheets
- Generate Holded sales invoices from new Google Sheets rows
- Create a new row at top in Google Sheets for every new purchase invoice in Holded
Related Zap Templates
- Create rows in Google Sheets for new Holded sales invoices
- Add new Holded purchase invoices to Google Sheets as rows
- Create multiple rows in Google Sheets when new sales invoices occur in Holded
- Create multiple rows in Google Sheets for new purchase invoices in Holded
- Create sales orders in Holded from new rows in Google Sheets
- Create Google Sheets rows for new Holded contacts
- Create Google Sheets rows for every new sales order in Holded
- Create new Holded contacts from new or updated rows in Google Sheets team drive
- Update Google Sheets rows when new sales invoices are created in Holded
- Create purchase invoices in Holded for new or updated rows in Google Sheets
- Create Holded contacts from new Google Sheets rows
- Create multiple spreadsheet rows in Google Sheets for new contacts in Holded
- Create Google Sheets rows for new Holded sales receipts
- Create Holded contacts from new or updated Google Sheets rows
- Create Holded sales invoices from new or updated Google Sheets rows