Formstack Documents + Google Sheets + Xero Integrations

How to connect Formstack Documents + Google Sheets + Xero

Zapier lets you send info between Formstack Documents and Google Sheets and Xero automatically—no code required. With 7,000+ supported apps, the possibilities are endless.

Choose a Trigger

Start here arrow pointing down

Choose an Action

Start free with email

Start free with Google

Start free with email

Start free with Google

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

Do even more with Formstack Documents + Google Sheets + Xero

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 Formstack Documents, Google Sheets, and Xero. And don’t forget that you can add more apps and actions to create complex workflows.

Supported triggers and actions

What does this mean?

New Merged Document
Triggers when a merged/populated document is created.
Trigger
Instant
Try It
- FileRequired
Action
Write
- DocumentRequired
- Download File
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Scheduled
Try It
- Drive
Trigger
Scheduled
Try It

- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Column NameRequired
- Index
Action
Write

- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- TitleRequired
- Spreadsheet to Copy
- Headers
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
Action
Write
- Api Docs Info
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
Action
Search or write
- OrganizationRequired
- Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
- Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Project State
Trigger
Scheduled
Try It
- OrganizationRequired
- Quote Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Status
Trigger
Instant
Try It
- OrganizationRequired
- Status
- Change
- Contact
- Trigger Preference
- Copy
Trigger
Instant
Try It
- OrganizationRequired
- InvoiceRequired
Action
Write
- OrganizationRequired
- Credit Note IDRequired
- Invoice IDRequired
- AmountRequired
Action
Write
- OrganizationRequired
- From AccountRequired
- To AccountRequired
- AmountRequired
- Date
Action
Write
- OrganizationRequired
- ContactRequired
- Date
- Expiry
- Quote Number
- Reference
- Theme
- Title
- Summary
- Currency
- Amounts Are
- Terms
Action
Write
- OrganizationRequired
- Invoice IDRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Reference
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- Document Type
- Document ID or NumberRequired
- Paid ToRequired
- Date
- Currency Rate
- AmountRequired
- Reference
Action
Write
- OrganizationRequired
- Contact (supplier)Required
- Date
- Delivery Date
- Order Number
- Reference
- Theme
- Currency
- Tax Type
- Delivery Address
- Attention
- Telephone
- Delivery Instructions
- Attachments
- Purchase Order Status
Action
Write
- OrganizationRequired
- Purchase OrderRequired
- Contact
- Update Method for Line Items
- Date
- Delivery Date
- Line Amount Types
- Purchase Order Number
- Reference
- Branding Theme
- Currency
- Status
- Sent to Contact
- Delivery Address
- Attention To
- Telephone
- Delivery Instructions
- Expected Arrival Date
Action
Write
- OrganizationRequired
- Resource typeRequired
- FileRequired
Action
Write
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Search or write

- OutputRequired
- File Name
- File 1Required
- File 2
- File 3
- File 4
- File 5
Action
Write
- RouteRequired
- Download File
Action
Write
- FileRequired
Action
Write
- No Team Drive
- SpreadsheetRequired
- WorksheetRequired
Trigger
Instant
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Trigger Column
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
Trigger
Scheduled
Try It
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- Spreadsheet Containing the Worksheet to CopyRequired
- Worksheet to CopyRequired
- Copy Worksheet Destination
Action
Write
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- RowRequired
- Background Color
- Text Color
- Text Bold
- Text Italic
- Text Strikethrough
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
Action
Write
- Drive
- SpreadsheetRequired
- WorksheetRequired
- Lookup ColumnRequired
- Lookup ValueRequired
- Supporting Lookup Column
- Supporting Lookup Value
- Search from last row
- Row Count
Action
Search
- Drive
- SpreadsheetRequired
- WorksheetRequired
- ColumnsRequired
- Row CountRequired
- First Row
Action
Search
- Drive
- SpreadsheetRequired
- TitleRequired
- Headers
- Overwrite existing worksheets
Action
Search or write
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
- Purchase Order Status
Trigger
Scheduled
Try It
- OrganizationRequired
- Payment Type
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
Trigger
Scheduled
Try It
- OrganizationRequired
- Invoice IDRequired
- NoteRequired
Action
Write
- OrganizationRequired
- Transaction TypeRequired
- ContactRequired
- Bank AccountRequired
- Date
Action
Write
- OrganizationRequired
- Contact NameRequired
- Account Number
- Contact Requirements
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Secondary Person - First Name
- Secondary Person - Last Name
- Secondary Person - Email
- Include secondary person in emails sent to contact?
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
- Contact Number
- Company Number
- Payment Terms - Invoice Due (days)
- Payment Terms - Type for Sales Invoices
- Payment Terms - Bill Due (days)
- Payment Terms - Type for Purchase Invoices
Action
Write
- OrganizationRequired
- TypeRequired
- ContactRequired
- Date
Action
Write
- OrganizationRequired
- Mark Item as a Sales Item?
- Mark Item as a Purchase Item?
- Item Name
- Item CodeRequired
Action
Write
- OrganizationRequired
- Contact NameRequired
- Email Address
- Contact Account Number
- Primary Person - First Name
- Primary Person - Last Name
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Contact Address Type
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Contact Tax Number
- Bank Account Number
- Contact Number
- Status
- Date
- Due Date
- Currency
- Url
- Attachment
- Branding Theme
- Number
- Reference
- Sent To Contact
- Line Items Type
- Item Code
- Description
- QuantityRequired
- Unit Price
- Discount %
- Discount Amount
- Account
- Tax Rate
- Tracking
Action
Write
- OrganizationRequired
- ContactRequired
- Project NameRequired
- Deadline for the project
- Project Estimate
Action
Write
- OrganizationRequired
- ContactRequired
- Repeated Invoice Schedule
- Invoice Creation: Frequency TypeRequired
- Invoice Creation: Frequency (Period)Required
- Due Date Type: Payment TermsRequired
- Set Due Dates (Days)Required
- Start Date: Required
- End Date
- StatusRequired
- Currency
- Branding Theme
- Reference
- Mark as approved for sending?
- Email a copy to Sender?
- Include PDF
- Line Amount Types
Action
Write
- Info
- OrganizationRequired
- Invoice IdRequired
- Contact
- Status
- Date
- Due Date
- Expected Payment Date
- Reference
- Branding Theme
- Url
- Currency
- Sent To Contact
- Attachments
- Invoice Number
- Line Amount Types
Action
Write
- HTTP MethodRequired
- URLRequired
- Query String Parameters
- Headers
- Additional Request Headers
- Body
Action
Write
- OrganizationRequired
Action
Search
- OrganizationRequired
- Invoice IDRequired
Action
Search
- OrganizationRequired
- Search ByRequired
- Contact NameRequired
- Account Number
- Contact Requirements
- Primary Person - First Name
- Primary Person - Last Name
- Primary Person - Email
- Secondary Person - First Name
- Secondary Person - Last Name
- Secondary Person - Email
- Include secondary person in emails sent to contact?
- Phone - Country Code
- Phone - Area Code
- Phone Number
- Fax - Country Code
- Fax - Area Code
- Fax - Number
- Mobile - Country Code
- Mobile - Area Code
- Mobile - Number
- Direct Dial - Country Code
- Direct Dial - Area Code
- Direct Dial - Number
- Address Type Of
- Address - Attention
- Address - Line 1
- Address - Line 2
- Address - City/Town
- Address - State/Region
- Address - Postal/Zip Code
- Address - Country
- Tax Number
- Bank Account Number
- Groups
- Contact Number
- Company Number
- Payment Terms - Invoice Due (days)
- Payment Terms - Type for Sales Invoices
- Payment Terms - Bill Due (days)
- Payment Terms - Type for Purchase Invoices
Action
Search or write

Top companies trust Zapier to automate work and free up time

Join millions worldwide who automate their work using Zapier

How Formstack Documents + Google Sheets + Xero Integrations Work

Step 1: Authenticate Formstack Documents, Google Sheets, and Xero.
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 Formstack Documents + Google Sheets + Xero

About Formstack Documents

Introducing Formstack Documents, formerly WebMerge. Automatically generate PDF and Word DOCX documents merged with data from online web services. Contracts, invoices, applications, tickets, and more - all created dynamically, saving you time and money.

Learn more

Related categories

Documents

Similar apps

About Google Sheets

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

Learn more Help

Related categories

Similar apps

About Xero

Xero is an accounting app that lets you track businesses expenses and accounting with intuitive mobile apps and web interfaces for point-of-sale, ecommerce, time-tracking, and more.

Learn more Help

Related categories

Accounting

Similar apps

Other Google Sheets + Xero Integrations

trello

Formstack Documents + Google Sheets + Xero Integrations

How to connect Formstack Documents + Google Sheets + Xero

Do even more with Formstack Documents + Google Sheets + Xero

New Merged Document

Convert File to PDF

Create Document Merge

New Spreadsheet Row (Team Drive)

New Spreadsheet

New or Updated Spreadsheet Row

Create Spreadsheet Column

Create Multiple Spreadsheet Rows

Create Spreadsheet

Clear Spreadsheet Row

Update Spreadsheet Row

API Request (Beta)

Find Worksheet

Lookup Spreadsheet Row

Find or Create Row

New Bill

New Credit Note

New Project

New Quote

New Sales Invoice

Updated Sales Invoice

Add Items to Existing Sales Invoice

Allocate Credit Note to Invoice

Create Bank Transfer

Create New Quote Draft

Send Sales Invoice by Email

Create Bill

Create Payment

Create Purchase Order

Update Purchase Order

Upload Attachment

Find Contact

Find Invoice

Find Item

Find or Create Item

Combine Files

Create Data Route Merge

Extract Field Values From PDF

New Spreadsheet Row

New or Updated Spreadsheet Row (Team Drive)

New Worksheet

Create Spreadsheet Row

Copy Worksheet

Create Worksheet

Format Spreadsheet Row

Update Spreadsheet Row(s)

Lookup Spreadsheet Rows (Advanced)

Get many Spreadsheet Rows (Advanced)

Find or Create Worksheet

New Bank Transaction

New Contact

New Payment

New Purchase Order

New Reconciled Payment

New or Updated Contact

Updated Quote

Add Note to Invoice

Create Bank Transaction

Create/Update Contact

Create Credit Note

Create Inventory Item

Create Sales Invoice

Create Project

Create Repeating Sales Invoice

Update Sales Invoice

API Request (Beta)

Find Purchase Order

Get Invoice History

Find or Create Contact

Join millions worldwide who automate their work using Zapier

About Formstack Documents

Related categories

Similar apps

Google Docs

Dropbox

Quip

About Google Sheets