Integrate Fatture in Cloud with Microsoft Excel to automate your work
1. Choose a Trigger
An event that starts an automation
2. Choose an Action
The event an automation performs after it's triggered
Endless possibilities
How Zapier works
Zapier makes it easy to integrate Fatture in Cloud with Microsoft Excel - no code necessary. See how you can get setup in minutes.
Zapier is the automation platform of choice for 87% of Forbes Cloud 100 companies in 2023
93%
Customers who say using Zapier has made them better at their job
25m
Customers have created over 25 million Zaps on the platform
6 mins
The average user takes less than 6 minutes to set up a Zap
Set up your first integration
Quickly connect Fatture in Cloud to Microsoft Excel with a Zapier template.
Our most popular template
Connect Fatture in Cloud and Microsoft Excel to unlock the power of automation
With Zapier's 7,000 integrations, you can unify your tools within a connected system to improve your team's efficiency and deepen their impact.
Choose a Trigger
Start here
Start here
Choose an Action
Supported triggers and actions
Zapier helps you create workflows that connect your apps to automate repetitive tasks. A trigger is an event that starts a workflow, and an action is an event a Zap performs.
- Company IDRequired
- Resource TypeRequired
- Event TypesRequired
Try It- Company IDRequired
- Archive document id - [data.id]
- Archive document date - [data.date]
- Archive Document description - [data.description]
- [Temporary] [Read Only] Archive Document url of the attached file - [data.attachment_url]
- Archive document category - [data.category]
- [Write Only] [Required] Archive document attachment token returned by POST /archive/attachment - [data.attachment_token]
- Company IDRequired
- Archive document id - [data.id]
- Client code - [data.code]
- Client name - [data.name]
- Cashbook type - [data.type]
- Client first name - [data.first_name]
- Client last name - [data.last_name]
- Client contact person - [data.contact_person]
- Client vat number - [data.vat_number]
- Client tax code - [data.tax_code]
- Client address street - [data.address_street]
- Client address postal code - [data.address_postal_code]
- Client address city - [data.address_city]
- Client address province - [data.address_province]
- Client address extra info - [data.address_extra]
- Client country - [data.country]
- Client country iso code - [data.country_iso]
- Client email - [data.email]
- Client certified email - [data.certified_email]
- Client phone - [data.phone]
- Client fax - [data.fax]
- Client extra - [data.notes]
- Vat type id - [data.default_vat.id]
- [Read Only] Vat type percentual value - [data.default_vat.value]
- Vat type short description - [data.default_vat.description]
- Vat type notes shown in documents - [data.default_vat.notes]
- Vat type is usable for e-invoices - [data.default_vat.e_invoice]
- Vat type e-invoice type (natura) - [data.default_vat.ei_type]
- Vat type e-invoice description - [data.default_vat.ei_description]
- [Read Only] Is the vat type is editable. - [data.default_vat.editable]
- Is the vat type disabled - [data.default_vat.is_disabled]
- If the vat type is default - [data.default_vat.default]
- Client default payment terms - [data.default_payment_terms]
- Payment terms type - [data.default_payment_terms_type]
- Payment method id - [data.default_payment_method.id]
- Payment method name - [data.default_payment_method.name]
- Payment method type - [data.default_payment_method.type]
- Payment method is default - [data.default_payment_method.is_default]
- Payment account id - [data.default_payment_method.default_payment_account.id]
- Payment account name - [data.default_payment_method.default_payment_account.name]
- Payment account type - [data.default_payment_method.default_payment_account.type]
- Payment account iban - [data.default_payment_method.default_payment_account.iban]
- Payment account sia - [data.default_payment_method.default_payment_account.sia]
- Payment account cuc - [data.default_payment_method.default_payment_account.cuc]
- Payment method is virtual - [data.default_payment_method.default_payment_account.virtual]
- Payment method details title - [data.default_payment_method.details.title]
- Payment method details description - [data.default_payment_method.details.description]
- Payment method bank iban - [data.default_payment_method.bank_iban]
- Payment method bank name - [data.default_payment_method.bank_name]
- Payment method bank beneficiary - [data.default_payment_method.bank_beneficiary]
- E-invoice payment method - [data.default_payment_method.ei_payment_method]
- Client bank name - [data.bank_name]
- Client bank iban - [data.bank_iban]
- Client bank swift code - [data.bank_swift_code]
- Client shipping address - [data.shipping_address]
- Use e-invoices for this entity - [data.e_invoice]
- Client e-invoice code - [data.ei_code]
- Highlight Discount - [data.discount_highlight]
- Client default discount - [data.default_discount]
- Client has intent declaration - [data.has_intent_declaration]
- Client intent declaration protocol number - [data.intent_declaration_protocol_number]
- Client intent declaration protocol date - [data.intent_declaration_protocol_date]
- Client creation date - [data.created_at]
- Client last update date - [data.updated_at]
- Company IDRequired
- Archive document id - [data.id]
- Entity id - [data.entity.id]
- Entity code - [data.entity.code]
- Entity name - [data.entity.name]
- Entity type - [data.entity.type]
- Entity first name - [data.entity.first_name]
- Entity last name - [data.entity.last_name]
- Entity contact person - [data.entity.contact_person]
- Entity vat number - [data.entity.vat_number]
- Entity tax code - [data.entity.tax_code]
- Entitity address street - [data.entity.address_street]
- Entity address postal code - [data.entity.address_postal_code]
- Entity address city - [data.entity.address_city]
- Entity address province - [data.entity.address_province]
- Entity address extra info - [data.entity.address_extra]
- Entity country - [data.entity.country]
- Entity country iso code - [data.entity.country_iso]
- Entity email - [data.entity.email]
- Entity certified email - [data.entity.certified_email]
- Entity phone - [data.entity.phone]
- Entity fax - [data.entity.fax]
- Entity extra - [data.entity.notes]
- [Only for client] Client default payment terms - [data.entity.default_payment_terms]
- Vat type id - [data.entity.default_vat.id]
- [Read Only] Vat type percentual value - [data.entity.default_vat.value]
- Vat type short description - [data.entity.default_vat.description]
- Vat type notes shown in documents - [data.entity.default_vat.notes]
- Vat type is usable for e-invoices - [data.entity.default_vat.e_invoice]
- Vat type e-invoice type (natura) - [data.entity.default_vat.ei_type]
- Vat type e-invoice description - [data.entity.default_vat.ei_description]
- [Read Only] Is the vat type is editable. - [data.entity.default_vat.editable]
- Is the vat type disabled - [data.entity.default_vat.is_disabled]
- If the vat type is default - [data.entity.default_vat.default]
- Payment terms type - [data.entity.default_payment_terms_type]
- Payment method id - [data.entity.default_payment_method.id]
- Payment method name - [data.entity.default_payment_method.name]
- Payment method type - [data.entity.default_payment_method.type]
- Payment method is default - [data.entity.default_payment_method.is_default]
- Payment account id - [data.entity.default_payment_method.default_payment_account.id]
- Payment account name - [data.entity.default_payment_method.default_payment_account.name]
- Payment account type - [data.entity.default_payment_method.default_payment_account.type]
- Payment account iban - [data.entity.default_payment_method.default_payment_account.iban]
- Payment account sia - [data.entity.default_payment_method.default_payment_account.sia]
- Payment account cuc - [data.entity.default_payment_method.default_payment_account.cuc]
- Payment method is virtual - [data.entity.default_payment_method.default_payment_account.virtual]
- Payment method details title - [data.entity.default_payment_method.details.title]
- Payment method details description - [data.entity.default_payment_method.details.description]
- Payment method bank iban - [data.entity.default_payment_method.bank_iban]
- Payment method bank name - [data.entity.default_payment_method.bank_name]
- Payment method bank beneficiary - [data.entity.default_payment_method.bank_beneficiary]
- E-invoice payment method - [data.entity.default_payment_method.ei_payment_method]
- [Only for client] Client bank name - [data.entity.bank_name]
- [Only for client] Client bank iban - [data.entity.bank_iban]
- [Only for client] Client bank swift code - [data.entity.bank_swift_code]
- [Only for client] Client Shipping address - [data.entity.shipping_address]
- [Only for client] Use e-invoices. - [data.entity.e_invoice]
- [Only for client] E-invoices code. - [data.entity.ei_code]
- [Only for client] Has intent declaration. - [data.entity.has_intent_declaration]
- [Only for client] Client intent declaration protocol number - [data.entity.intent_declaration_protocol_number]
- [Only for client] Client intent declaration protocol date - [data.entity.intent_declaration_protocol_date]
- Entity creation date - [data.entity.created_at]
- Entity last update date - [data.entity.updated_at]
- Cashbook type - [data.type]
- Issued document number [If not specified, next number is used] - [data.number]
- Issued document numeration [Not available if type=delivery_note] - [data.numeration]
- Archive document date - [data.date]
- Issued document year - [data.year]
- Currency code - [data.currency.id]
- Currency symbol - [data.currency.symbol]
- Currency exchange rate (EUR to this) - [data.currency.exchange_rate]
- Currency html code - [data.currency.html_symbol]
- Language code - [data.language.code]
- Language extended name - [data.language.name]
- Issued document subject [not shown on the PDF] - [data.subject]
- Issued document visible subject - [data.visible_subject]
- Issued document revenue center [or cost center if type=supplier_order]. - [data.rc_center]
- Client extra - [data.notes]
- Issued document "Rivalsa INPS" percentual value - [data.rivalsa]
- Issued document "Cassa previdenziale" percentual value - [data.cassa]
- [Read Only] Issued document cassa amount. - [data.amount_cassa]
- Issued document cassa taxable percentage - [data.cassa_taxable]
- [Can be set only if cassa_taxable is NULL] Issued document cassa taxable amount - [data.amount_cassa_taxable]
- Issued document "Cassa previdenziale 2" percentual value - [data.cassa2]
- [Read Only] Issued document cassa2 amount - [data.amount_cassa2]
- Issued document cassa2 taxable percentage - [data.cassa2_taxable]
- [Can be set only if cassa2_taxable is NULL] Issued document cassa2 taxable amount - [data.amount_cassa2_taxable]
- Issued document global cassa taxable percentage - [data.global_cassa_taxable]
- [Can be set only if global_cassa_taxable is NULL] Issued document global cassa taxable amount - [data.amount_global_cassa_taxable]
- Issued document withholding tax (ritenuta d'acconto) percentual value - [data.withholding_tax]
- Issued document withholding tax taxable (imponibile) percentual value - [data.withholding_tax_taxable]
- Issued document other withholding tax (altra ritenuta) percentual value - [data.other_withholding_tax]
- Issued document stamp duty value [0 if not present] - [data.stamp_duty]
- Payment method id - [data.payment_method.id]
- Payment method name - [data.payment_method.name]
- Payment method type - [data.payment_method.type]
- Payment method is default - [data.payment_method.is_default]
- Payment account id - [data.payment_method.default_payment_account.id]
- Payment account name - [data.payment_method.default_payment_account.name]
- Payment account type - [data.payment_method.default_payment_account.type]
- Payment account iban - [data.payment_method.default_payment_account.iban]
- Payment account sia - [data.payment_method.default_payment_account.sia]
- Payment account cuc - [data.payment_method.default_payment_account.cuc]
- Payment method is virtual - [data.payment_method.default_payment_account.virtual]
- Payment method details title - [data.payment_method.details.title]
- Payment method details description - [data.payment_method.details.description]
- Payment method bank iban - [data.payment_method.bank_iban]
- Payment method bank name - [data.payment_method.bank_name]
- Payment method bank beneficiary - [data.payment_method.bank_beneficiary]
- E-invoice payment method - [data.payment_method.ei_payment_method]
- Issued document uses split payment - [data.use_split_payment]
- Issued document uses gross prices - [data.use_gross_prices]
- Use e-invoices for this entity - [data.e_invoice]
- Vat kind [esigibilità IVA] - [data.ei_data.vat_kind]
- Issued document original document type - [data.ei_data.original_document_type]
- E-invoice original document number - [data.ei_data.od_number]
- E-invoice original document date - [data.ei_data.od_date]
- E-invoice CIG - [data.ei_data.cig]
- E-invoice CUP - [data.ei_data.cup]
- E-invoice payment method [required for e-invoices] (see [here](https://www.fatturapa.gov.it/export/documenti/fatturapa/v1.2.2/Rappresentazione_Tabellare_FattOrdinaria_V1.2.2.pdf) for the accepted values of ModalitaPagamento) - [data.ei_data.payment_method]
- E-invoice bank name - [data.ei_data.bank_name]
- E-invoice bank IBAN - [data.ei_data.bank_iban]
- E-invoice bank beneficiary - [data.ei_data.bank_beneficiary]
- E-invoice invoice number - [data.ei_data.invoice_number]
- E-invoice invoice date - [data.ei_data.invoice_date]
- E-invoice cassa type - [data.ei_cassa_type]
- E-invoice cassa2 type - [data.ei_cassa2_type]
- E-invoice withholding tax causal - [data.ei_withholding_tax_causal]
- E-invoice other withholding tax type - [data.ei_other_withholding_tax_type]
- E-invoice other withholding tax causal - [data.ei_other_withholding_tax_causal]
- Issued document item id - [data.items_list.id]
- Issued document item product id - [data.items_list.product_id]
- Issued document item product code - [data.items_list.code]
- Issued document item product name - [data.items_list.name]
- Issued document item product category - [data.items_list.category]
- Issued document product description - [data.items_list.description]
- Issued document item quantity - [data.items_list.qty]
- Issued document item measure - [data.items_list.measure]
- Issued document item net price - [data.items_list.net_price]
- Issued document item gross price - [data.items_list.gross_price]
- Vat type id - [data.items_list.vat.id]
- [Read Only] Vat type percentual value - [data.items_list.vat.value]
- Vat type short description - [data.items_list.vat.description]
- Vat type notes shown in documents - [data.items_list.vat.notes]
- Vat type is usable for e-invoices - [data.items_list.vat.e_invoice]
- Vat type e-invoice type (natura) - [data.items_list.vat.ei_type]
- Vat type e-invoice description - [data.items_list.vat.ei_description]
- [Read Only] Is the vat type is editable. - [data.items_list.vat.editable]
- Is the vat type disabled - [data.items_list.vat.is_disabled]
- If the vat type is default - [data.items_list.vat.default]
- Issued document item is not taxable - [data.items_list.not_taxable]
- Issued document item apply withholding taxes, rivalsa and cassa - [data.items_list.apply_withholding_taxes]
- Issued document item discount percentual value - [data.items_list.discount]
- Issued document item highlight discount - [data.items_list.discount_highlight]
- Issued document item add in delivery note - [data.items_list.in_dn]
- Issued document item move stock - [data.items_list.stock]
- Issued document advanced raw attributes for e-invoices - [data.items_list.ei_raw]
- Issued document payment item id - [data.payments_list.id]
- Issued document payment due date - [data.payments_list.due_date]
- Issued document payment amount - [data.payments_list.amount]
- Issued document status - [data.payments_list.status]
- Payment account id - [data.payments_list.payment_account.id]
- Payment account name - [data.payments_list.payment_account.name]
- Payment account type - [data.payments_list.payment_account.type]
- Payment account iban - [data.payments_list.payment_account.iban]
- Payment account sia - [data.payments_list.payment_account.sia]
- Payment account cuc - [data.payments_list.payment_account.cuc]
- Payment method is virtual - [data.payments_list.payment_account.virtual]
- Issued document payment date [Only if status is paid] - [data.payments_list.paid_date]
- Issued document payment advanced raw attributes for e-invoices - [data.payments_list.ei_raw]
- Issued document payment number of days by which the payment must be made - [data.payments_list.payment_terms.days]
- Payment terms type - [data.payments_list.payment_terms.type]
- Template id - [data.template.id]
- Template name - [data.template.name]
- Template type - [data.template.type]
- Template id - [data.delivery_note_template.id]
- Template name - [data.delivery_note_template.name]
- Template type - [data.delivery_note_template.type]
- Template id - [data.acc_inv_template.id]
- Template name - [data.acc_inv_template.name]
- Template type - [data.acc_inv_template.type]
- Issued document PDF horizontal margins - [data.h_margins]
- Issued document PDF vertical margins - [data.v_margins]
- Show the expiration dates of the payments on the document - [data.show_payments]
- Show the payment method details on the document - [data.show_payment_method]
- Show totals mode - [data.show_totals]
- Show notification button in the PDF - [data.show_notification_button]
- Show ts pay button in the PDF - [data.show_tspay_button]
- Issued document has delivery note - [data.delivery_note]
- Issued document has an accompanying invoice - [data.accompanying_invoice]
- Issued document attached delivery note number - [data.dn_number]
- Issued document attached delivery note date - [data.dn_date]
- Issued document attached delivery note number of packages - [data.dn_ai_packages_number]
- Issued document attached delivery note package weight - [data.dn_ai_weight]
- Issued document attached delivery note causal - [data.dn_ai_causal]
- Issued document attached delivery note destination - [data.dn_ai_destination]
- Issued document attached delivery note transporter - [data.dn_ai_transporter]
- Issued document attached delivery note notes - [data.dn_ai_notes]
- Issued document is marked - [data.is_marked]
- [Read only] Issued document total net amount - [data.amount_net]
- [Read Only] Issued document total vat amount - [data.amount_vat]
- [Read Only] Issued document total gross amount - [data.amount_gross]
- Issued document amount due discount - [data.amount_due_discount]
- [Read Only] Issued document rivalsa amount - [data.amount_rivalsa]
- Issued document taxable rivalsa amount - [data.amount_rivalsa_taxable]
- [Read Only] Issued document withholding tax amount (ritenuta d'acconto). - [data.amount_withholding_tax]
- Issued document taxable withholding tax amount - [data.amount_withholding_tax_taxable]
- [Read Only] Issued document other withholding tax amount (altra ritenuta) - [data.amount_other_withholding_tax]
- Issued document taxable other withholding tax amount - [data.amount_other_withholding_tax_taxable]
- Issued document taxable enasarco amount - [data.amount_enasarco_taxable]
- [data.extra_data.multifatture_sent]
- Send issued document to "Sistema Tessera Sanitaria" - [data.extra_data.ts_communication]
- Issued document ts "tipo spesa" [TK, FC, FV, SV,SP, AD, AS, ECG, SR] - [data.extra_data.ts_flag_tipo_spesa]
- Issued document ts traced payment - [data.extra_data.ts_pagamento_tracciato]
- Can be [ 'TK', 'FC', 'FV', 'SV', 'SP', 'AD', 'AS', 'SR', 'CT', 'PI', 'IC', 'AA' ]. Refer to the technical specifications to learn more. - [data.extra_data.ts_tipo_spesa]
- Issued document ts "opposizione" - [data.extra_data.ts_opposizione]
- Issued document ts status - [data.extra_data.ts_status]
- Issued document ts file id - [data.extra_data.ts_file_id]
- Issued document ts sent date - [data.extra_data.ts_sent_date]
- Issued document ts total amount - [data.extra_data.ts_full_amount]
- Issued document imported by software - [data.extra_data.imported_by]
- Issued document seen date - [data.seen_date]
- Issued document date of the next not paid payment - [data.next_due_date]
- [Temporary] [Read Only] Issued document url of the document PDF file - [data.url]
- [Temporary] [Read Only] Issued document url of the attached delivery note PDF file - [data.dn_url]
- [Temporary] [Read Only] Issued document url of the accompanying invoice PDF file - [data.ai_url]
- [Temporary] [Read Only] Archive Document url of the attached file - [data.attachment_url]
- [Write Only] [Required] Archive document attachment token returned by POST /archive/attachment - [data.attachment_token]
- Issued document advanced raw attributes for e-invoices - [data.ei_raw]
- [Read only] Status of the e-invoice. * **attempt** - We are trying to send the invoice, please wait up to 2 hours * **missing** - The invoice is missing * **not_sent** - The invoice has yet to be sent * **sent** - The invoice was sent * **pending** - The checks for the digital signature and sending are in progress * **processing** - The SDI is delivering the invoice to the customer * **error** - An error occurred while handling the invoice, please try to resend it or contact support * **discarded** - The invoice has been rejected by the SDI, so it must be corrected and re-sent * **not_delivered** - The SDI was unable to deliver the invoice * **accepted** - The customer accepted the invoice * **rejected** - The customer rejected the invoice, so it must be corrected * **no_response** - A response has not yet been received whithin the deadline, contact the customer to ascertain the status of the invoice * **manual_accepted** - The customer accepted the invoice * **manual_rejected** - The customer rejected the invoice - [data.ei_status]
- Issued Document can't be edited - [data.locked]
- Client creation date - [data.created_at]
- Client last update date - [data.updated_at]
- Fixes your last payment amount to match your document total - [options.fix_payments]
- Original documents ids [only for join/transform] - [options.create_from]
- Tranform a document [only for transform] - [options.transform]
- Keep original document [only for transform] - [options.keep_copy]
- Join type [only for join] - [options.join_type]
- Company IDRequired
- Resource TypeRequired
- Event TypesRequired
Try It- Company IDRequired
- Archive document id - [data.id]
- Archive document date - [data.date]
- Archive Document description - [data.description]
- Cashbook kind - [data.kind]
- Cashbook type - [data.type]
- Cashbook entity name - [data.entity_name]
- Cashbook related document id - [data.document.id]
- Cashbook related document type - [data.document.type]
- Cashbook related document path - [data.document.path]
- [Only for cashbook entry in] Cashbook total amount in - [data.amount_in]
- Payment account id - [data.payment_account_in.id]
- Payment account name - [data.payment_account_in.name]
- Payment account type - [data.payment_account_in.type]
- Payment account iban - [data.payment_account_in.iban]
- Payment account sia - [data.payment_account_in.sia]
- Payment account cuc - [data.payment_account_in.cuc]
- Payment method is virtual - [data.payment_account_in.virtual]
- [Only for cashbook entry out] Cashbook total amount out - [data.amount_out]
- Payment account id - [data.payment_account_out.id]
- Payment account name - [data.payment_account_out.name]
- Payment account type - [data.payment_account_out.type]
- Payment account iban - [data.payment_account_out.iban]
- Payment account sia - [data.payment_account_out.sia]
- Payment account cuc - [data.payment_account_out.cuc]
- Payment method is virtual - [data.payment_account_out.virtual]
- Company IDRequired
- Archive document id - [data.id]
- F24 due date - [data.due_date]
- F24 status - [data.status]
- Payment account id - [data.payment_account.id]
- Payment account name - [data.payment_account.name]
- Payment account type - [data.payment_account.type]
- Payment account iban - [data.payment_account.iban]
- Payment account sia - [data.payment_account.sia]
- Payment account cuc - [data.payment_account.cuc]
- Payment method is virtual - [data.payment_account.virtual]
- F24 amount - [data.amount]
- [Temporary] [Read Only] Archive Document url of the attached file - [data.attachment_url]
- [Write Only] [Required] Archive document attachment token returned by POST /archive/attachment - [data.attachment_token]
- Archive Document description - [data.description]
- Company IDRequired
- Archive document id - [data.id]
- Client name - [data.name]
- Cashbook type - [data.type]
- Payment account iban - [data.iban]
- Payment account sia - [data.sia]
- Payment account cuc - [data.cuc]
- Payment method is virtual - [data.virtual]
Learn how to automate Microsoft Excel on the Zapier blog
Related categories
Microsoft's Excel is a spreadsheet application used by millions of users across the world. It is part of the Office ecosystem and is considered the industry standard for spreadsheets.
Only files on OneDrive for Business (available with Office 365 and Sharepoint server) are supported at this time with Zapier.
Related categories