Kajabi + Google Sheets + Fattura24 Integrations
How to connect Kajabi + Google Sheets + Fattura24
Zapier lets you send info between Kajabi, Google Sheets, and Fattura24 automatically—no code required.
- Free forever for core features
- 14 day trial for premium features & apps
Do even more with Kajabi + Google Sheets + Fattura24
With Zapier, you can do more than just connect your apps - you can automate entire processes from beginning to end! Check out the following list of triggers and actions you can use with Kajabi, Google Sheets, and Fattura24. And don’t forget that you can add more apps and actions to create complex workflows.
SiteRequired
Choose the site that the assessment will come from.
AssessmentRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SiteRequired
Choose the site that the purchases will come from.
Offer
Leave blank if you want to trigger this for all offers.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Tag
SiteRequired
Choose the site that the form submission will come from.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SiteRequired
FormRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planNo Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
Column NameRequired
Index
The column position (zero-based) to insert. If not set, append to the right by default.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
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
Create a duplicate of an existing spreadsheet.
Headers
These Headers are ignored if a "Spreadsheet to Copy" is selected.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
Use a search step before this to get the row to delete.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Api Docs Info
API docs for Google Sheets are located here https://developers.google.com/sheets/api/reference/rest
HTTP MethodRequired
URLRequired
Requests can only be made to domains associated by this application.
Query String Parameters
These params will be URL-encoded and appended to the URL when making the request.
Headers
Authentication headers are included automatically
Additional Request Headers
Zapier will apply these optional headers and values to the request in addition to any headers created as part of the authentication mechanism.
Body
Zapier will pass this along raw. If you would like to provide complex JSON, try a "Code by Zapier" step to build the structure and pass it along here. For example,
{"foo": "bar"}is perfectly valid.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Specify the column we should search for cells which match the Lookup Value.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet? In other words, pick the most recent match?
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 TypeRequired
Which document you want to create. If you choose "Invoice/Receipt", it will be created an invoice if the customer has a Vat Number, otherwise a receipt; choose Invoice to force this logic.
Vat Chargeability
Choose if you want VAT charged instantly or by split payment.
Document Date
Put here date of the document if different from date of payment.
Codice Destinatario
Codice Destinatario, obbligatorio per la fattura elettronica.
Indirizzo PEC
Indirizzo PEC, obbligatorio per fatturazione elettronica.
Send EmailRequired
Do you want to send an email to the customer with PDF of the document attached?
Amounts FormatRequired
If you choose 'Euro' all values will be multiplied by 1, else will be multiplied by 0.01.
Total AmountRequired
Total amount of the document, including taxes. Use ONLY a dot as decimal separator.
Total Vat Amount
Enter a total value or specify a Vat value for each product. Required if "Product Vat Value" is left empty. Use ONLY a dot as decimal separator.
Object
A description of the document.
Foot Notes
Foot Notes that will be inserted in the PDF.
Pdf Template
here you can choose the PDF template you wish to use in Fattura24 by entering in this input field the ID of your favourite template. You can find it in your Fattura24 account, clicking on Settings->Template settings->Invoice settings (for invoices) than pick the number on ID column corresponding to your favourite template
Invoice Number format
here you can choose a custom issue number format for invoices or receipt. To do this, enter the ID you find in Fattura24->Settings->Advanced->Issue numbers, then click on your custom issue number format and copy the ID number from the top right angle of the dialog
Order id
Put here the order id (optional)
Currency
By default you will create your document in Euro, otherwise choose the currency
FE Virtual Stamp
Apply virtual stamp only if you are in VAT exempt fiscal regime and order total is bigger than 77.47 Euro. Note: You will pay the stamp on behalf of your customer
Additional Data (JSON)
Put here additional document data in JSON format. Sample : {"2.1.6":[{"2.1.6.2":"1423-2023-FE","2.1.6.3":"2023-02-05"}]}
Customer NameRequired
Full name or company name.
Customer Address
Customer City
Customer Province
Customer Postcode
Customer Country
Customer Fiscal Code
Customer Vat Number
In case CustomerCountry is NOT Italy and the field is left empty we will send CustomerName data as Customer Vat Code for FE tech specs compliance
Customer Email
The email of the customer.
Customer Telephone Number
The telephone number of the customer.
Delivery Name
Shipping fields.
Delivery Address
Shipping fields.
Delivery Postcode
Zip or Postal Code.
Delivery City
Shipping city.
Delivery Province
Shipping province.
Delivery Country
Shipping country.
Product ID
Used to update product stock levels in Fattura24.
Product NameRequired
Name or description of the product.
Product Quantity
Product PriceRequired
Use ONLY a dot as decimal separator.
Product Discount
Use ONLY floating point for decimals.
Product Vat Value
Enter Product Vat Value. Required if 'Totat Vat Amount' is left empty. Use ONLY a dot as decimal separator.
Product Vat Description
Product Vat Description, e.g.: 22%.
Product Vat Nature
Vat Nature, required only if Vat Description = 0 %.
Product Price Includes TaxesRequired
Product Vat TypeRequired
Choose if you want to insert a Percentage Rate or a Fixed Amount in "Product Vat Value".
Product Pdc
here you can add your custom PDC to each product. To do this enter the ID of your PDC, you'll find it in your Fattura24 account, by clicking on Settings->Advanced->POC, then click on the desired row. You will find the ID on the top right angle of the dialog window
Shipping Method Description
Shipping fields.
Shipping Amount
Total cost of delivery. Use ONLY a dot as decimal separator.
Shipping Discount Amount
Total discount amount on shipping cost. Use ONLY floating point for decimals.
Shipping Vat Value
Enter Shipping Vat Value. Required if 'Shipping Amount' is NOT empty and 'Total Vat Amount' is left empty. Use ONLY dot for decimals.
Shipping Vat Description
Shipping Vat Description, e.g.: 22%.
Shipping Vat Nature
Shipping Vat Nature, required only if Vat Description = 0 %.
Shipping Amount Includes Taxes
Shipping Vat Type
Choose if you want to insert a Percentage Rate or a Fixed Amount in "Shipping Vat Value".
Paid
Is this document paid?
Payment Date
If you leave this field blank, we will get the current date.
Payment Method Options
Select the correct payment method.
Payment Method Name
In caso di pagamento con bonifico inserire il nome della banca.
Payment Method Description
Inserire il codice IBAN senza spazi se il metodo scelto è il bonifico bancario.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
SiteRequired
Choose the site that the form submission will come from.
FormRequired
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SiteRequired
Choose the site that the form submission will come from.
Tag
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.SiteRequired
OfferRequired
Member NameRequired
EmailRequired
External User IDRequired
An ID to uniquely identify the user. This is used to grant or revoke access later.
Send Offer Grant Email?
Send member an Offer Grant Confirmation email?
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Site IDRequired
Offer IDRequired
External User IDRequired
The ID that was sent when granting access to this offer.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.No Team Drive
If you want to use this trigger with a Sheet that resides in your Google Team Drive, you have to workaround the issue using these steps.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Try ItTriggerThis is the start of your ZapInstantThis event starts a Zap instantly.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers
Trigger Column
Trigger on changes to cells in this column only. Leave this field blank if you want the Zap to trigger on changes to any cell within the row. Please note: All new rows will trigger the Zap even if the Trigger column is empty. Add a Filter step to stop the Zap from continuing if this column is empty in a new row.
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
Try ItTriggerThis is the start of your ZapScheduledZapier checks for new data every 15 min on the Free planDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
Spreadsheet Containing the Worksheet to CopyRequired
Worksheet to CopyRequired
Copy To
Which spreadsheet should the worksheet be copied to? If left blank, it will be copied to the spreadsheet containing the original worksheet.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
RowRequired
If you want to update the same row each time select a row from the dropdown box. To dynamically update the row, click open the dropdown and choose the "Custom" tab, then the "Add a search step" button.
Background Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Color
Choose from your current custom Theme Color in your Spreadhseet, or enter a color #rrggbb in hexadecimal format.
Text Bold
True if the text is bold.
Text Italic
True if the text is italicized.
Text Strikethrough
True if the text is strikethrough.
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Drive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
Lookup ColumnRequired
Let us know which column you want to search by with the value below. We will grab the latest matching row and give you all of its values.
Lookup ValueRequired
Supporting Lookup Column
Optionally, specify another column you want to search by. Note that if you supply this, the Zap will trigger only on rows that match both columns. (An example column might be something like Email Address or Phone Number)
Supporting Lookup Value
An example value might be me@example.com or 555-5555
Bottom-Up
Search from bottom of the sheet?
Row Count
Number of rows to return. Max is 500.
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
WorksheetRequired
You must have column headers. See here for more information.
ColumnsRequired
Let us know which columns to return. e.g. A:Z
Row CountRequired
Number of rows to return. Max is 500.
First Row
Number of the first row to return (1 is the header)
ActionThis is an event a Zap performs.SearchFind existing data in your appDrive
The Google Drive where your spreadsheet resides. If nothing is selected, then your personal Google Drive will be used. If you are connected with any Google Team Drives, you can select it here.
SpreadsheetRequired
TitleRequired
Value of the Worksheet Title to match exactly. Search is case-sensitive.
Headers
Overwrite?
If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
ActionThis is an event a Zap performs.Search or writeFind existing data in your app, or create a new record if no data is foundName
Full name or company name. Either the Name or Email field is required. If only Email is supplied, a contact will be created with the Email as the Name. If a contact exists with this Name, it will be updated.
Email
Contact Type
Pec Address
Indirizzo di Posta Elettronica Certificata.
Destination Code
Codice Destinatario, obbligatorio per fatturazione elettronica.
Fiscal Code
If a contact exists with this Fiscal Code, it will be updated.
Vat Code
If a contact exists with this Vat Code, it will be updated.
Address
Postcode
City
Province
Country
Telephone Number
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.Payment Method Name
Enter the name of the payment method (es.: POS).
Payment Method Description
Insert here the description of the payment method, IBAN for bank wire.
Total Without TaxRequired
Enter here the total amount.
Vat AmountRequired
Enter here the Vat Amount.
TotalRequired
Enter here the total fee.
Foot Notes
PriceRequired
Enter the Price paid.
Vat CodeRequired
Vat DescriptionRequired
ActionThis is an event a Zap performs.WriteCreate a new record or update an existing record in your app.
Top companies trust Zapier to automate work and free up time
Connect your apps and automate workflows
Easy automation for busy people. Zapier moves info between your web apps automatically, so you can focus on your most important work.
How Kajabi + Google Sheets + Fattura24 Integrations Work
- Step 1: Authenticate Kajabi, Google Sheets, and Fattura24.30 seconds
- Step 2: Pick one of the apps as a trigger, which will kick off your automation.15 seconds
- Step 3: Choose a resulting action from the other app.15 seconds
- Step 4: Select the data you want to send from one app to the other.2 minutes
- That’s it! More time to work on other things.
About Kajabi
Related categories
Similar apps
WooCommerce
eCommerce, WordPress
Gumroad
eCommerce
Simplero
Online Courses
About Google Sheets
Related categories
Similar apps
Zoho Creator
App Builder, Zoho
Smartsheet
Spreadsheets
Quip
Documents
About Fattura24
Related categories
Get started for free
You can't add more hours to the day. Zapier is the next best thing.
Other Kajabi + Google Sheets Integrations
- clickfunnels
- thrivecart
- convertkit
- hubspot
- typeform
- facebook-lead-ads
- sms
- zoom
- mailchimp
- google-drive
- trello
- stripe
- simpletexting
- pipedrive
- leadconnector
- google-forms
- clicksend
- leadpages
- jotform
- clickup
- airtable
- shopify
- monday
- klaviyo
- kartra
- facebook-custom-audiences
- deadline-funnel
- aweber
- asana
- manychat
- getresponse
- code
- webinarjam
- twilio
- streak
- shipstation
- ontraport
- keap
- gravity-forms
- gotowebinar
- easywebinar
- drip
- discord
- circle
- woocommerce
- wix-automations
- wicked-reports
- wati
- upviral
- trustpulse
- textedly
- superphone
- squarespace
- square
- sharpspring
- segmetrics
- scheduleonce
- regfox
- quickbooks
- proof
- poptin
- paypal
- paykickstart
- payfunnels
- notion
- mysql
- mixpanel
- mightynetworks
- mailerlite
- linkedin-lead-gen-forms
- learndash
- klick-tipp
- justcall
- interact
- intakeq
- instapage
- instamojo
- infinity
- google-chat
- google-calendar
- follow-up-boss
- flodesk
- facebook-lead-ads-beta
- facebook-groups
- facebook-conversions
- eventbrite
- email-parser
- elite-funnels
- dubsado
- dropbox
- docusign
- dialmycalls
- demio
- databox
- corsizio
- closeio
- chatwork
- campaign-monitor
- calendly
- bucketio-2
- better-proposals
- autopilot
- acuity-scheduling
- accredible