Google Sheets

Google Sheets Functions & Syntax

Get integration

Overview

Google Sheets is a web-based spreadsheet program offered by Google. With this spreadsheet integration for Google Sheets and Microsoft Excel, you can access data from other Google Sheets without sharing the sheet or exposing the sheet as a link.

What you can do

With this integration, you can:

  • Access data from Google Sheets in Excel or other Google Sheets
  • Share data from Google Sheets without exposing the source
  • Enrich data in spreadsheets using the contents of other sheets as a lookup

What you need

You need to have have a Google account. Also, if you haven't already installed the Flex.io add-on for Excel or Google Sheets, you need to set this up as well.

Functions and Syntax

This integration for Microsoft Excel or Google Sheets includes the following functions:

Need help?

Have questions? Need help getting started? Need other Google Sheets templates or functions for Microsoft Excel or Google Sheets? Chat with us; we're happy to help!