Factomos + Google Sheets Integrations

How to connect Factomos + Google Sheets

Zapier lets you send info between Factomos and Google Sheets automatically—no code required.

When this happens...

automatically do this!

Free forever for core features
14 day trial for premium features & apps

Quickly automate Factomos and Google Sheets workflows with Zapier's templates

Our most popular Zap! arrow pointing down

Create invoices in Factomos from new Google Sheets spreadsheet rows
Try it
Google Sheets + Factomos
More details
When this happens
Step 1: New Spreadsheet Row
Then do this
Step 2: Create Invoice
See Zap details Try it
Create invoices in Factomos from new Google Sheets spreadsheet rows
Create invoices in Factomos from new Google Sheets spreadsheet rows
Google Sheets + Factomos

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.

By signing up, you agree to Zapier's terms of service and privacy policy.

Supported triggers and actions

What does this mean?

- Article NameRequired
  The name of the article, will be displayed in the quotes / invoices lines
- Article Type
  Type of the article among (service, product)
- Article description
  The description of the article
- Article unit
  Unit of the article (day, kg, etc ...)
- Article price
  Price of the article
- Article supplier price
  The article price of the supplier
- Vat rate
  Vat rate of the article in percentage, if not present, will be the default vat rate of the account (ex: 20, for France: Taux de TVA)
Action
Write
- ContactRequired
  Public Id of the contact, can be retrieve with the action "Find Contact"
- Estimate subject
  Subject of the estimate
- Estimate attention
  Attention of the estimate (To the attention of)
- Estimate date
  Date of the estimate (ex: 2021-02-10), If not present, will be current date
- Article IdRequired
  Public Id of the article, can be retrieve with the action "Find Article"
- Article description
  If not present, will be the default description of the article
- QuantityRequired
  Number of articles for this line
- Price
  Price of the Article, if not present will be the default price of the article
- Vat rate
  Vat rate in percentage (ex: 20), if not present will be the default rate of the article For France : Taux de TVA
- Estimate Comment
  Comment at the end of the estimate
Action
Write
- Invoice PIDRequired
  The invoice pid given by Factomos after creating the invoice
- Payment type
  The type of the payment to set in Factomos. Possible values are : "transfer": Bank transfer, "card": Credit/Debit card, "check": Check, "cash": Cash, "order": Direct debit, "other": Any other payment method
- Payment date
  The date of the payment, given by WooCommerce
- Total amount paidRequired
  Total amount paid (with taxes) for the order, given by WooCommerce
Action
Write
- Article ReferenceRequired
  The article's reference, in common with Factomos
- Article PriceRequired
  The article's price in WooCommerce
- Article Total VATRequired
  The article's total vat (excluding taxes, for total quantity) from WooCommerce
- Article QuantityRequired
  Total quantity of this article in order on WooCommerce
- Article NameRequired
  Article name, given by WooCommerce
- Article description
  The article description (under the title in the invoice). For all articles except shipping which will be the shipping method.
- Article Product ID
  WooCommerce product ID for the given article (only useful for Article Images)
- Default Article PID
  If article not found, use this default PID (creating non-existing articles in factomos is not supported at the moment)
- Shipping Article PID
  The PID of the article dedicated to shipping in Factomos, so as to show a line in the invoice for shipping costs. If empty, there will be no shipping.
- Shipping Total
  Total shipping fees for the invoice, excluding taxes (HT)
- Shipping Tax
  The total taxes paid for shipping, via WooCommerce
- Tax Lines Rate Percent
  The different tax rates that can be applied, from WooCommerce
- Tax Lines Totals
  The total taxes paid per tax type, given by WooCommerce
- Total paidRequired
  Total paid for the order, given by WooCommerce
- Total taxes paidRequired
  Total taxes paid for the order, given by WooCommerce
- Shipping MethodRequired
  The shipping methods given by WooCommerce
- Image ID
  The id (= product id) resulting from the optional "Find Article Images" step
- Image SRC
  The image src (url) given by the optional "Find Article Images" step
Action
Search
- Article ReferenceRequired
  The article's reference, in common with Factomos
- Article priceRequired
  Price of the article
- Article Total VATRequired
  The article's total vat (excluding taxes, for total quantity) from WooCommerce
- Article QuantityRequired
  Total quantity of this article in order on WooCommerce
- Article NameRequired
  Article name, given by WooCommerce
- Article description
  The description of the article
- Article Product ID
  WooCommerce product ID for the given article (only useful for Article Images)
- Default Article PID
  If article not found, use this default PID (creating non-existing articles in factomos is not supported at the moment)
- Shipping Article PID
  The PID of the article dedicated to shipping in Factomos, so as to show a line in the invoice for shipping costs. If empty, there will be no shipping.
- Shipping Total
  Total shipping fees for the invoice, excluding taxes (HT)
- Shipping Tax
  The total taxes paid for shipping, via WooCommerce
- Tax Lines Rate Percent
  The different tax rates that can be applied, from WooCommerce
- Tax Lines Totals
  The total taxes paid per tax type, given by WooCommerce
- Total paidRequired
  Total paid for the order, given by WooCommerce
- Total taxes paidRequired
  Total taxes paid for the order, given by WooCommerce
- Shipping MethodRequired
  The shipping methods given by WooCommerce
- Image ID
  The id (= product id) resulting from the optional "Find Article Images" step
- Image SRC
  The image src (url) given by the optional "Find Article Images" step
- Article NameRequired
  The name of the article, will be displayed in the quotes / invoices lines
- Article Type
  Type of the article among (service, product)
- Article unit
  Unit of the article (day, kg, etc ...)
- Article supplier price
  The article price of the supplier
- Vat rate
  Vat rate of the article in percentage, if not present, will be the default vat rate of the account (ex: 20, for France: Taux de TVA)
Action
Search or write

- 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
Scheduled
Try It
- 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.
Trigger
Scheduled
Try It

- 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
- 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.
Trigger
Instant
Try It
- 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.
Action
Write
- 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
Action
Write
- TitleRequired
- Spreadsheet to Copy
  Create a duplicate of an existing spreadsheet.
- Headers
  These Headers are ignored if a "Spreadsheet to Copy" is selected.
Action
Write
- 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.
Action
Write
- 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.
Action
Write
- 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.
Action
Write
- 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.
Action
Search
- 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
  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?
Action
Search
- 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
  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?
Action
Search or write

- Contact Type
  Type of contact among (prospect, client, supplier)
- Contact Company Name
  Required if Client Type is Enterprise (B2B).
- Contact Reference
  Internal reference of your contact
- Registration number
  Registration number of the company. For france, it is : SIRET
- Vat Number
  For France : N° TVA.
- Contact's website
  Website URL of your contact
- Client Phone number
  The phone number of your client
- Contact Description
  Internat Comments about your client
- Contact title
  The title of the contact among ('MR', 'MRS', '')
- First name
  First name of the contact
- Last nameRequired
  The last name of the contact
- E-mail
  The email of the contact
- Phone number
  The phone number of the contact
- Contact Language
  The language of the contact for the futur quotes or invoices
- Address
  Street number and name of the address
- Address More
- Zipcode
- City
- Country
  Country iso code (ex: FR, ES)
Action
Write
- ContactRequired
  Public Id of the contact, can be retrieve with the action "Find Contact"
- Invoice object
  Subject of the invoice
- Invoice attention
  Attention of the invoice (To the attention of)
- Invoice date
  Date of the invoice (ex: 2021-02-10), If not present, will be current date
- Date of Payment
  Date of payment (deadline, ex: 2021-02-10), if not present will be the default deadline of the account
- Invoice Paid Mention
  Is the invoice paid or not ? 'pay_before ' : display the mention "Payable before <invoice_due_date>" 'paid' : display the mention "Paid <invoice_due_date>" 'pay_on_receive': display the mention "Pay on receive"
- Prices include tax?
  If prices in Factomos and Woocommerce are defined including taxes (TTC), set to true
- Article idRequired
  Public Id of the articles in Factomos
- Article title
  The name of the article from WooCommerce.
- Article quantity
  The quantity of the article ordered
- Article price
  The unit price of the article (without taxes)
- Article VAT Rate
  The VAT rate for this article
- Article Total VAT
  The total VAT paid for this article (for whole quantity)
- Article description
  The description for the article
- Article line mode
  The "line_mode" section from the "Find Articles" step, useful in case of article images.
- Invoice Comment
  Comment at the end of the invoice
- Invoice creation mode in FactomosRequired
  DRAFT INVOICE to test the creation of an invoice. This will create a draft invoice in factomos, that will need to be manually validated to become a real invoice. REAL INVOICE only once everything seems to work, to use live with real orders.
- Send invoice to customer via email
  Set to TRUE to automatically send the invoice to the customer's email address via Factomos after creating it.
Action
Write
- WooCommerce Website DomainRequired
  The domain of your WooCommerce website, formatted like www.myshop.com
- WooCommerce API Consumer KeyRequired
  Found in WooCommerce admin (see documentation)
- WooCommerce API Consumer SecretRequired
  Found in WooCommerce admin (see documentation)
- Product ID
  The WooCommerce product ID
Action
Write
- Keyword
  keyword to search among the following fields: client_company_name, description, last name, email, reference, siret
Action
Search
- Keyword
  keyword to search among the following fields: client_company_name, description, last name, email, reference, siret
- Contact Type
  Type of contact among (prospect, client, supplier)
- Contact Company Name
  Required if Client Type is Enterprise (B2B).
- Contact Reference
  Internal reference of your contact
- Registration number
  Registration number of the company. For france, it is : SIRET
- Vat Number
  For France : N° TVA.
- Contact's website
  Website URL of your contact
- Client Phone number
  The phone number of your client
- Contact Description
  Internat Comments about your client
- Contact title
  The title of the contact among ('MR', 'MRS', '')
- First name
  First name of the contact
- Last nameRequired
  The last name of the contact
- E-mail
  The email of the contact
- Phone number
  The phone number of the contact
- Contact Language
  The language of the contact for the futur quotes or invoices
- Address
  Street number and name of the address
- Address More
- Zipcode
- City
- Country
  Country iso code (ex: FR, ES)
Action
Search or write
- 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
Trigger
Instant
Try It
- 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.
Trigger
Scheduled
Try It
- 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
Trigger
Scheduled
Try It
- 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
Action
Write
- 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.
Action
Write
- 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.
Action
Write
- 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.
Action
Write
- 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
Action
Write
- 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.
Action
Search
- 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.
- 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)
Action
Search
- 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.
- Headers
- Overwrite?
  If a worksheet with the specified title exists, its content would be lost. Please, use with caution.
Action
Search or write

How Factomos + Google Sheets Integrations Work

Step 1: Authenticate Factomos and Google Sheets.
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.

Connect apps

Connect Factomos + Google Sheets

Google Sheets Tutorials

About Factomos

Factomos is an invoicing tool that can help you create invoices and quotes.

Related categories

Accounting

About Google Sheets

Create, edit, and share spreadsheets wherever you are with Google Sheets, and get automated insights from your data.

Learn more

Related categories

Similar apps

Zoho Creator

App Builder, Zoho

Smartsheet

Spreadsheets

Quip

Documents

Get started for free

You can't add more hours to the day. Zapier is the next best thing.

By signing up, you agree to Zapier's terms of service and privacy policy.

Factomos + Google Sheets Integrations

How to connect Factomos + Google Sheets

Create invoices in Factomos from new Google Sheets spreadsheet rows

Create invoices in Factomos from new Google Sheets spreadsheet rows

Connect your apps and automate workflows

Create Article

Article Type

Article description

Article unit

Article price

Article supplier price

Vat rate

Create Estimate

ContactRequired

Estimate subject

Estimate attention

Estimate date

Article IdRequired

Article description

QuantityRequired

Price

Vat rate

Estimate Comment

Create Payment

Invoice PIDRequired

Payment type

Payment date

Total amount paidRequired

Find Articles

Article ReferenceRequired

Article PriceRequired

Article Total VATRequired

Article QuantityRequired

Article NameRequired

Article description

Article Product ID

Default Article PID

Shipping Article PID

Shipping Total

Shipping Tax

Tax Lines Rate Percent

Tax Lines Totals

Total paidRequired

Total taxes paidRequired

Shipping MethodRequired

Image ID

Image SRC

Find or Create Articles

Article ReferenceRequired

Article priceRequired

Article Total VATRequired

Article QuantityRequired

Article NameRequired

Article description

Article Product ID

Default Article PID

Shipping Article PID

Shipping Total

Shipping Tax

Tax Lines Rate Percent

Tax Lines Totals

Total paidRequired

Total taxes paidRequired

Shipping MethodRequired

Image ID

Image SRC

Article NameRequired

Article Type

Article unit

Article supplier price

Vat rate

New Spreadsheet Row (Team Drive)

Drive

SpreadsheetRequired

WorksheetRequired

New Spreadsheet

Drive

New or Updated Spreadsheet Row

No Team Drive

SpreadsheetRequired