Evoliz + Google Sheets
Create Evoliz clients from new Google Sheets spreadsheet rows
Set up this integration to streamline your client management work. Thanks to this Zap, you can automatically create your new client from the details included in each new row you add to a specified Google Sheets spreadsheet.
Set up this integration to streamline your client management work. Thanks to this Zap, you can automatically create your new client from the details included in each new row you add to a specified Google Sheets spreadsheet.
- 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 ClientCreates a Client
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 foundAdvance's status
Payment method id
Analytic axis id
Client id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planBank item bank id
Search param
Bank item movement
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free plan
New Client Contact
Triggers when a new client contact is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDelivery's status
Payment method id
Analytic axis id
Delivery's client id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planExpense's status
Payment method id
Analytic axis id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Invoice (Unpaid)
Triggers when a new invoice's payment is late.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planQuote's status
Payment method id
Analytic axis id
Organization's type
Quote's client id
Quote's prospect id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Supplier
Triggers when a new supplier is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planArticle referenceRequired
Article designationRequired
Article type
Article quantity
Article weight
Article quantity unit
Article unit price
Article VAT rate
Billing option
Article purchase unit price
Article reference from the supplier
Stock management for the article
Article stocked quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The client's id to attach the contact toRequired
Contact last nameRequired
Contact emailRequired
Contact client civility
Contact first name
Contact profil
Contact consent informations
Primary phone label
Primary phone number
Secondary phone label
Secondary phone number
Tertiary phone label
Tertiary phone number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The supplier's id to attach the buy toRequired
The buy total including vatRequired
Document dateRequired
Label of the buyRequired
Document number
External document number written on the document
Payment term identifier
Payment type identifier
Item total excluding vatRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IdRequired
Payment entry dateRequired
Payment labelRequired
Payment method idRequired
Payment amountRequired
Comments on the payment
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External Document numberRequired
Document dateRequired
The client's id to attach the quote to
The prospect's id to attach the quote to
Payment term identifierRequired
Object on the document
Penalty rate
Use legal mention about penalty rate
Use legal collection cost
Discount rate, prohibited if no_discount_term is true
No relevant discount rate
Payment type identifier
Comments on the quote with html
Validity duration of the document in days
Delivery date of the document
Quote rebate
Indicate whether to include sale general conditions in the document PDF or not
Analytic axis id
Item designation with html
Item quantity
Item unit price excluding vat
Item reference with html
Quantity unit
Item VAT rate
Item rebate
Item sale classification id
Article unique identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Quote idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Draft Invoice IdRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Quote idRequired
Email recipient addressRequired
Send copy to your user email address
Subject of the email
Body of the email in txt or Html
Send signature of your company in the email
Add the PDF document as an attachment
Contact client civility
Contact last name
Contact first name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client IdRequired
Client code
Client name
Client type
Address line 1
Address line 2
Postcode
Town
Country
Delivery Address line 1
Delivery Address line 2
Delivery Postcode
Delivery Town
Delivery Country
Bank name
Bank account details
International Bank Account Number
Bank Identifier Code (BIC, SWIFT)
Client phone number
Client mobile number
Client website URL
Client legal form
Client business Number (SIRET)
Client intra-community VAT number
Client activity number
Client immatriculation number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client code identifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appUserIdRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appClient codeRequired
Client nameRequired
Client typeRequired
PostcodeRequired
TownRequired
Iso2 country codeRequired
Address line 1
Address line 2
Delivery Postcode
Delivery Town
Delivery Iso2 country code
Delivery Address line 1
Delivery Address line 2
Bank name
Bank account details
International Bank Account Number
Bank Identifier Code (BIC, SWIFT)
Client phone number
Client mobile number
Client website URL
Client legal form
Client business Number (SIRET)
Client intra-community VAT number
Client activity number
Client immatriculation number
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDocument numberRequired
External Document numberRequired
Document dateRequired
The client's id to attach the invoice toRequired
Payment term identifierRequired
Object on the document
Penalty rate, prohibited if no_penalty is true
Define the display of legal mention about penalty rate on the created document
Use legal mention about recovery indemnity
Discount rate, prohibited if no_discount_term is true
Define the display of the no discount applicable legal mention
Payment type identifier
Comments on the invoice with html
Invoice rebate
Execution date of payment terms
Indicate whether to include sale general conditions in the document PDF or not
Analytic axis id
Item designation with html
Item quantity
Item unit price excluding vat
Item reference with html
Quantity unit
Item VAT rate
Item rebate
Item sale classification id
Article unique identifier
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 Account
Triggers when a new account is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Article
Triggers when a new article is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Client
Triggers when a new client is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planCredit's status
Payment method id
Analytic axis id
Client id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNew Event
Triggers when a new event is created.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planInvoice's status.
Payment method id.
Analytic axis id
Client id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planPayment's type
Payment method id
Linked client Id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planOrder's status
Payment method id
Analytic axis id
Client id
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planAccount numberRequired
Account labelRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Client code
Client nameRequired
Client typeRequired
PostcodeRequired
TownRequired
Iso2 country codeRequired
Address line 1
Address line 2
Delivery Postcode
Delivery Town
Delivery Iso2 country code
Delivery Address line 1
Delivery Address line 2
Bank name
Bank account details
International Bank Account Number
Bank Identifier Code (BIC, SWIFT)
Client phone number
Client mobile number
Client website URL
Client legal form
Client business Number (SIRET)
Client intra-community VAT number
Client activity number
Client immatriculation number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.The prospect's id to attach the contact toRequired
Contact last nameRequired
Contact client civility
Contact first name
Contact profil
Contact email
Primary phone label
Primary phone number
Secondary phone label
Secondary phone number
Tertiary phone label
Tertiary phone number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External Document numberRequired
Document dateRequired
The client's id to attach the invoice toRequired
Payment term identifierRequired
Object on the document
Penalty rate, prohibited if no_penalty is true
Define the display of legal mention about penalty rate on the created document
Use legal mention about recovery indemnity
Discount rate, prohibited if no_discount_term is true
Define the display of the no discount applicable legal mention
Payment type identifier
Comments on the invoice with html
Invoice rebate
Execution date of payment terms
Indicate whether to include sale general conditions in the document PDF or not
Analytic axis id
Item designation with html
Item quantity
Item unit price excluding vat
Item reference with html
Quantity unit
Item VAT rate
Item rebate
Item sale classification id
Article unique identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Prospect nameRequired
PostcodeRequired
TownRequired
Country ISO2 codeRequired
Address line 1
Address line 2
Prospect activity number
Prospect business Number (SIRET)
Prospect intra-community VAT number
Prospect phone number
Prospect mobile number
Prospect website URL
Comments on this prospect
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.External Document numberRequired
Document dateRequired
The client's id to attach the sale order toRequired
Payment term identifierRequired
Object on the document
Penalty rate
Use legal mention about penalty rate
Use legal collection cost
Discount rate, prohibited if no_discount_term is true
No relevant discount rate
Payment type identifier
Comments on the sale order with html
Withdrawal period
Delivery date of the document
Sale order rebate
Indicate whether to include sale general conditions in the document PDF or not
Analytic axis id
Item designation with html
Item quantity
Item unit price excluding vat
Item reference with html
Quantity unit
Item VAT rate
Item rebate
Item sale classification id
Article unique identifier
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Order idRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Invoice IdRequired
Email recipient addressRequired
Send copy to your user email address
Subject of the email.
Body of the email in txt or Html
Send signature of your company in the email
Add the PDF document as an attachment
Contact client civility
Contact last name
Contact first name
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Article idRequired
Article reference
Article designation
Article type
Article quantity
Article weight
Article quantity unit
Article unit price
Article VAT rate
Billing option
Article purchase unit price, must be less than unit price vat excluded
Article reference from the supplier
Stock management for the article
Article stocked quantity
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Filter articles by referenceRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSearch byRequired
Search ContentRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appDocument numberRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appSupplier code identifierRequired
ActionThis is an event a Zap performs.SearchFind existing data in your appArticle referenceRequired
Article designationRequired
Article type
Article quantity
Article weight
Article quantity unit
Article unit price
Article VAT rate
Billing option
Article purchase unit price
Article reference from the supplier
Stock management for the article
Article stocked quantity
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundSearch byRequired
Search ContentRequired
The client's id to attach the contact toRequired
Contact last nameRequired
Contact emailRequired
Contact client civility
Contact first name
Contact profil
Contact consent informations
Primary phone label
Primary phone number
Secondary phone label
Secondary phone number
Tertiary phone label
Tertiary phone number
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundDocument numberRequired
External Document numberRequired
Document dateRequired
The client's id to attach the sale order toRequired
Payment term identifierRequired
Object on the document
Penalty rate
Use legal mention about penalty rate
Use legal collection cost
Discount rate, prohibited if no_discount_term is true
No relevant discount rate
Payment type identifier
Comments on the sale order with html
Withdrawal period
Delivery date of the document
Sale order rebate
Indicate whether to include sale general conditions in the document PDF or not
Analytic axis id
Item designation with html
Item quantity
Item unit price excluding vat
Item reference with html
Quantity unit
Item VAT rate
Item rebate
Item sale classification id
Article unique identifier
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 Evoliz
Evoliz is an invoicing and management software designed for small businesses but also their accountants.
Related categories
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
