---
title: Quick Guide to Set-Up an Automation Rule to Google Sheets
description: Quick Guide to Set-Up an Automation Rule to Google Sheets
---

[Skip to content](https://help.file.ai/quick-guide-to-set-up-an-automation-rule-to-google-sheets#main-content)

English

Show submenu for translations

[Customer portal](https://customerportal.file.ai/customerportal?hsLang=en)

![fileAI Logo—White.png\]](https://help.file.ai/hs-fs/hubfs/fileAI%20Logo%E2%80%94White.png?height=40&name=fileAI%20Logo%E2%80%94White.png)

Open main navigation

Close main navigation

- English
  
  Show submenu for translations
- [Customer portal](https://customerportal.file.ai/customerportal)
- Go to bluesheets.io

 Go to bluesheets.io

 Hello. How can we help you?

- There are no suggestions because the search field is empty.

1. [Help Centre](https://help.file.ai/?hsLang=en)
2. [Exporting Files](https://help.file.ai/exporting-files?hsLang=en)
3. [Exporting to Google Sheets](https://help.file.ai/exporting-files?hsLang=en#exporting-to-google-sheets)

# Quick Guide to Set-Up an Automation Rule to Google Sheets

 

1. Select “Google Sheets” as your export integration. Do ensure that your Google Sheets Integration is toggled on under the “Integration” tab before proceeding.
   
   ![](https://help.file.ai/hubfs/Screenshot%202022-06-21%20at%2014-27-26-png.png)
2. Select an existing Google Spreadsheet or choose to create a new one to have the data exported to.   
   ![](https://help.file.ai/hubfs/Screenshot%202022-06-21%20at%2014-28-29-png.png)
3. Choose the Type Export between the three options and proceed to indicate any fields that might be compulsory when you view the final data on Google Sheets.You can also choose to include any column filters to remove unnecessary information during the export  
   ![](https://help.file.ai/hubfs/Screenshot%202022-06-21%20at%2014-31-01-png.png)
4. Once you have reviewed and confirmed that everything is correct, select the “create rule” function.  
     1. Auto Publish - Toggle the “Auto Publish” function should you wish to export all future documents that match the same type.

![](https://help.file.ai/hubfs/Screenshot%202022-06-21%20at%2016-36-44-png.png)

- [Product Release Notes](https://help.file.ai/product-release-notes?hsLang=en#main-content)
  
  
  
  
  
    - [Q3 2024](https://help.file.ai/product-release-notes?hsLang=en#q3-2024)
- [FAQs](https://help.file.ai/faqs?hsLang=en)
- [Get Started](https://help.file.ai/get-started?hsLang=en#main-content)
  
  
  
  
  
    - [About fileAI](https://help.file.ai/get-started?hsLang=en#about-fileai)
- [Login & Account](https://help.file.ai/login-account?hsLang=en#main-content)
  
  
  
  
  
    - [Workspaces](https://help.file.ai/login-account?hsLang=en#workspaces)
    - [Organizations](https://help.file.ai/login-account?hsLang=en#organizations)
    - [Billing, subscriptions, payments](https://help.file.ai/login-account?hsLang=en#billing-subscriptions-payments)
    - [Account errors](https://help.file.ai/login-account?hsLang=en#account-errors)
    - [Account Deletion](https://help.file.ai/login-account?hsLang=en#account-deletion)
- [Uploading Files](https://help.file.ai/uploading-files?hsLang=en#main-content)
  
  
  
  
  
    - [Upload Methods](https://help.file.ai/uploading-files?hsLang=en#upload-methods)
    - [Common Questions](https://help.file.ai/uploading-files?hsLang=en#common-questions)
    - [Integration Guides](https://help.file.ai/uploading-files?hsLang=en#integration-guides)
    - [Mobile App](https://help.file.ai/uploading-files?hsLang=en#mobile-app)
- [Processing Files](https://help.file.ai/processing-files?hsLang=en#main-content)
  
  
  
  
  
    - [How documents are processed](https://help.file.ai/processing-files?hsLang=en#how-documents-are-processed)
    - [Common Questions](https://help.file.ai/processing-files?hsLang=en#common-questions)
    - [Common Errors](https://help.file.ai/processing-files?hsLang=en#common-errors)
- [File Inbox](https://help.file.ai/file-inbox?hsLang=en#main-content)
  
  
  
  
  
    - [Workspace Menu](https://help.file.ai/file-inbox?hsLang=en#workspace-menu)
    - [Organization Menu](https://help.file.ai/file-inbox?hsLang=en#organization-menu)
- [Working with Processed Files](https://help.file.ai/working-with-processed-files?hsLang=en#main-content)
  
  
  
  
  
    - [Creating Workflows](https://help.file.ai/working-with-processed-files?hsLang=en#creating-workflows)
    - [Creating Rules](https://help.file.ai/working-with-processed-files?hsLang=en#creating-rules)
    - [Error in Processed Files](https://help.file.ai/working-with-processed-files?hsLang=en#error-in-processed-files)
- [Exporting Files](https://help.file.ai/exporting-files?hsLang=en#main-content)
  
  
  
  
  
    - [Common Questions](https://help.file.ai/exporting-files?hsLang=en#common-questions)
    - [Exporting to Xero](https://help.file.ai/exporting-files?hsLang=en#exporting-to-xero)
    - [Xero Export Errors](https://help.file.ai/exporting-files?hsLang=en#xero-export-errors)
    - [Exporting to QuickBooks](https://help.file.ai/exporting-files?hsLang=en#exporting-to-quickbooks)
    - [Exporting to Netsuite](https://help.file.ai/exporting-files?hsLang=en#exporting-to-netsuite)
    - [Exporting to Bukku](https://help.file.ai/exporting-files?hsLang=en#exporting-to-bukku)
    - [Exporting to Google Sheets](https://help.file.ai/exporting-files?hsLang=en#exporting-to-google-sheets)
    - [Exporting to third-party tools (via API)](https://help.file.ai/exporting-files?hsLang=en#exporting-to-third-party-tools-via-api)
    - [Exporting to Zoho Books](https://help.file.ai/exporting-files?hsLang=en#exporting-to-zoho-books)
- [For Accountants](https://help.file.ai/for-accountants?hsLang=en#main-content)
  
  
  
  
  
    - [Setting up your firm in fileAI](https://help.file.ai/for-accountants?hsLang=en#setting-up-your-firm-in-fileai)
- [Expense Claims](https://help.file.ai/expense-claims?hsLang=en)
- [Mobile App](https://help.file.ai/mobile-app?hsLang=en)
- [fileForge](https://help.file.ai/fileforge?hsLang=en)

# fileAI

Last Updated: June 2025 / support@file.ai

<https://www.linkedin.com/company/file-ai/>

Copyright © 2026, fileAI

```json
{
  "@context" : "https://schema.org",
  "@type" : "VideoObject",
  "contentUrl" : "https://stream.mux.com/rjT79cs7UMcJTunKWcVDzScTJQX95DyKjEnX13Qn00YE/capped-1080p.mp4",
  "dateModified" : "2024-12-17T01:46:32.628Z",
  "duration" : "PT1M25S",
  "height" : 1024,
  "name" : "Export to Google Sheets v2",
  "thumbnailUrl" : "https://7752746.fs1.hubspotusercontent-na2.net/hubfs/7752746/Export%20to%20Google%20Sheets%20v2.mp4/medium.jpg",
  "uploadDate" : "2024-12-17T01:46:32.623Z",
  "width" : 2074
}
```