Google Sheets

Integrate Google Sheets 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.

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

• 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

• 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

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

• 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

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, tell us what you're after :)