> For the complete documentation index, see [llms.txt](https://docs.cascade.io/cascade/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cascade.io/cascade/integrations/gsheets.md).

# Google Sheets

Integrate [Google Sheets](https://docs.google.com/spreadsheets/) to gain, both import and publish-access to any tables and sheets within an authenticated Google Sheets account. Tables and sheets from that account, are made accessible to any workflow **within that Cascade workspace**. Accordingly, any team member(s) with access to the workspace, will have access to import and publish, from and to, the integrated Google Sheets account.

![](/files/SIGEFySqbFQrgZXFtifv)

### Workspace: Configure your Integration

In the top-left corner, confirm the workspace you are about to integrate with Google Sheets. Any team members with access to this workspace, will gain access to the integration and data within.

* From the left-nav of your workspace select the "Integrations" tab
* Select the "New Integration" button in the top-right corner
* Select "GSheets" to create a new (or additional) integration with Google Sheets
* In the provided field, name your integration
  * Note: Any name may be provided. However, it may be simplest to label it with the Google Sheets account name.
* Select "Sign in with Google" to connect to your account
  * Expect Google to ask for your user name
  * Expect Google to ask for your password
  * Expect Google to confirm permissions, select "Continue" to allow

![](/files/mDbvyPSueFvWtW2DnMcs)

* If authentication was successful, you will be returned to Workspace / Integrations / Edit Integration
  * The status of integration should change to "Connected"
  * Return to this page in the future, to make changes to this integration

### Canvas: Import from Integration

Open a new or existing workflow, from the now-integrated workspace. You'll be able to add the "Import from Integration" tool to your canvas.

* From the tool side panel, select "Import from Integration" to drill in
* Drag "Import from GSheets", from the tool side panel to the canvas
* Select the tool to configure it, options include:
  * Select Integration
    * Select the integration name, you provided earlier, for this Google Sheets account
  * Google Sheet URL
    * In another browser window, navigate to the Google Sheet you intend to import
    * Select the "Share" button, in the top-right corner
    * Select the "Copy Link" button, from the sharing dialog
    * Navigate back to Cascade, and paste your sharing-link into the provided field  
  * Select Sheets
    * Select the sheets in the Google Sheet that you'd like to import (there may only be one) 
    * Optionally, you may configure import settings for header rows

![](/files/g95ZN8ldSUbsR8K34n3v)

* With your configuration complete, make sure to **update the preview** of imported data
  * Select the "Update" button, from the bottom-right corner of the tool configuration dialog
  * If successful, your tabular data can now be previewed
  * Remember to "Save" your tool, before returning to the canvas 

![](/files/XdEE6JSfwWIdJfVZBvBr)

### Canvas: Publish to Integration

Publishing back to Google Sheets is as simple as importing. Open a new or existing workflow, from the now-integrated workspace. You'll be able to add the "Publish to Integration" tool to your canvas.

* From the tool side panel, select "Publish to Integration" to drill in
* Drag "Publish to GSheets", from the tool side panel to your canvas
  * Connect it to the downstream dataset you wish to publish to Google Sheets
* Select the Publish to GSheets tool to configure it, options include:
  * Select Integration
    * Select the integration name, you provided earlier, for this Google Sheets account
  * Google Sheet URL
    * In another browser window, navigate to the Google Sheet you intend to publish to
    * Select the "Share" button, in the top-right corner
    * Select the "Copy Link" button, from the sharing dialog
    * Navigate back to Cascade, and paste your sharing-link into the provided field
  * Select Sheet
    * Select the sheets in the Google Sheet that you'd like to import (there may only be one) 
    * Optionally, you may configure publish settings for header rows
  * Output Options
    * Select "Overwrite" to publish over any existing cells in the Google Sheet
    * Select "Append" to add to any existing cells in the Google Sheet

![](/files/UOgTPuGwzM6fvFxvXi3e)

* Be sure to "Save" your tool. Now, when you run your workflow, any tables connected to the Publish to GSheets tool will be send to the specified Google Sheet

{% hint style="info" %}
Don't get blocked by a data integration. If you need help configuring and integration or would like to recommend an integration, [**join the Cascade Slack Community**](https://cascadecommunity.slack.com/join/shared_invite/zt-nnen80j5-R6KcTALLlQEPnwCHF5N5Ig#/shared-invite/email), tell us what you're after :)
{% endhint %}