Cascade Library
  • Introduction
    • Welcome to Cascade
    • Workspaces
  • Getting Started
    • Build Your First Workflow
    • Build Your First Data App
  • Workflows
    • Overview
      • Navigating the Canvas
      • Setting Up
      • Drag and Drop
      • Tools
    • Dynamic Workflows
    • Global Variables
    • Data Locker
    • Scheduling
    • Webhooks
    • Run Logs
    • Workflow Deployment
  • Integrations
    • Connecting Cascade to your database
    • Amazon S3
    • Azure Blob Storage
    • BigQuery
    • Google Sheets
    • MySQL
    • Postgres
    • Redshift
    • SQL Server
    • Snowflake
    • Tableau Server
  • Tools
    • Import
      • Import File
      • Import from Data Locker
      • Import from API
      • Import Sample Data
      • New Table
    • Clean
      • Validate Schema
      • Find/Replace
      • Text to Columns
      • Flatten Json
      • Sample
      • Standardize
      • Validate
    • Transform
      • Edit Columns
      • Select Columns
      • Filter
      • Sort
      • Pivot
      • Unpivot
      • Deduplicate
    • Merge
      • Append
      • Join
      • Multi Join
      • Fuzzy Join
    • Predictive Modeling
      • Build Model
      • Apply Model
      • Correlate
      • ARIMA Forecast
    • Flow
      • Conditional
    • Code
      • Python
      • SQL
    • Visualize
      • Chart
        • Bar
        • Line
        • Combo
        • Scatter
        • Histogram
        • Box
        • Pie
        • Area
        • Funnel
    • Publish
      • Publish to Data Locker
      • Publish via Email
      • Publish to URL
      • Embed
  • Functions & Expressions
    • Functions
      • Aggregate Functions
        • AVERAGE
        • CORR
        • COUNT
        • COUNTD
        • COUNTBY
        • COUNTIF
        • COUNTIFS
        • COVAR
        • COVARP
        • COVARS
        • MAX
        • MEDIAN
        • MIN
        • MAXBY
        • MINBY
        • PERCENTILE
        • STDEV
        • STDEVP
        • STDEVS
        • SUM
        • SUMBY
        • SUMIF
        • VAR
        • VARP
        • VARS
        • RUNNINGTOTALBY
          • SIGN
          • SIN
          • SQRT
          • SQUARE
          • TAN
          • ZN
      • Conversion Functions
        • TIMESTAMPTODATE
        • TODATE
        • TODECIMAL
        • TOINT
      • Date/Time Functions
        • DATEADD
        • DATEDIF
        • DATENAME
        • DATENORMALIZE
        • DATEPART
        • DATETRUNC
        • DAY
        • DAYS
        • HOUR
        • ISDATE
        • ISOWEEKDAY
        • ISOWEEK
        • ISOQUARTER
        • ISOYEAR
        • MAKEDATE
        • MAKEDATETIME
        • MINUTE
        • MONTH
        • NOW
        • QUARTER
        • SECOND
        • TODAY
        • WEEK
        • WEEKDAY
        • YEAR
      • Logical Functions
        • AND
        • BETWEEN
        • CASE
        • CHOOSE
        • CONTAINSWITHIN
        • IF
        • IFS
        • IIF
        • IN
        • IFNULL
        • ISBOOLEAN
        • ISDECIMAL
        • ISDURATION
        • ISINTEGER
        • ISNULL
        • ISNUMBER
        • ISSTRING
        • ISUNIQUE
        • NOT
        • NULL
        • OR
        • SWITCH
        • ALL
          • TOSTRING
        • ANY
      • Math Functions
        • ABS
        • ACOS
        • ASIN
        • ATAN
        • ATAN2
        • CEILING
        • COS
        • COT
        • COSEC
        • DEGREES
        • DIV
        • EVEN
        • EXPONENTIAL
        • FILLINFINITY
        • FLOOR
        • HAVERSINE
        • LOG
        • LN
        • ODD
        • MODULO
        • PERCENTILEOFVALUE
        • PERCENTILEVALUE
        • PI
        • POWER
        • RADIANS
        • RANDOM
        • ROUND
        • SEC
      • Table Functions
        • ENCODE
        • INDEX
        • INDEXBY
        • FILLNULL
        • FIRSTBY
        • GENERATEUNIQUEID
        • LASTBY
        • LOOKUP
        • MATCH
        • NTH
        • OFFSET
        • OFFSETBY
        • PREVIOUSVALUE
        • RANK
        • RANKBY
        • RECORDID
        • ROLLINGAVERAGE
        • ROW
        • RUNNINGAVERAGE
        • RUNNINGMAX
        • RUNNINGMIN
        • RUNNINGSTDEV
        • RUNNINGTOTAL
        • WINDOWAVERAGE
        • WINDOWMAX
        • WINDOWMIN
        • WINDOWCOUNT
        • WINDOWSUM
        • SEQUENCE
        • WINDOWMEDIAN
        • WINDOWSTDEV
        • WINDOWSTDEVP
        • WINDOWSTDEVS
        • WINDOWVAR
        • WINDOWVARP
        • WINDOWVARS
        • WINDOWCORR
        • WINDOWCOVAR
        • WINDOWCOVARP
        • WINDOWCOVARS
        • SMOOTHEDAVERAGE
      • Text Functions
        • ASCII
        • CHAR
        • CONCAT
        • CONTAINS
        • ENDSWITH
        • FIND
        • FINDNTH
        • ISEMPTY
        • JSONPARSE
        • LEFT
        • LENGTH
        • LOWER
        • LTRIM
        • MID
        • PROPER
        • RIGHT
        • RTRIM
        • SPACE
        • SPLIT
        • STARTSWITH
        • TRIM
        • SUBSTITUTE
        • UPPER
    • Building Expressions
      • Expression Operators
      • Guide to Window Functions
  • Cascade FAQs
    • Best Practices
      • 💬How to add a total row to a table
      • 💬How to leave comments on a workflow
      • 💬How to add new columns in the Edit Columns tool
      • 💬Setting up a New Table tool
      • 💬How to rename a tool
    • Knowledge Based
      • 💬How to change Data Types in Cascade
      • 💬How to remove columns from a table in Cascade
      • 💬How to rename columns in Cascade
      • 💬Understanding the Join options in the Cascade Join tool
      • 💬How to connect tools to each other
    • Import
      • 💬How to Import an Excel File into Cascade
      • 💬How to Import a CSV File into Cascade
      • 💬How to import a CSV file into the Data Locker
    • Functions and Expressions
      • 💬How to write an IN() statement with multiple variables
      • 💬How to Remove null Records with a Filter tool
      • 💬How to write an IF Statement in Cascade
      • 💬How to replace null values with 0
    • Troubleshooting
      • ⚠️What does it mean if my workflow won’t load?
      • ⚠️Why can’t I connect my tool to other tools?
      • ⚠️Why are there duplicate records after my Join tool?
  • Change Log
On this page
  • Workspace: Configure your Integration
  • Canvas: Import from Integration
  • Canvas: Publish to Integration

Was this helpful?

  1. Integrations

Google Sheets

PreviousBigQueryNextMySQL

Last updated 2 years ago

Was this helpful?

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

join the Cascade Slack Community
Google Sheets