Phiona Documentation
  • 👋Introduction
  • 🛣️The Basics
    • How Phiona Works
    • Scheduling & Automation
    • API Documentation
  • 🔗Data Sources
    • Airtable
    • Amazon S3
    • BigCommerce
    • BigQuery
    • Dropbox
    • Firebase
    • Google Analytics v4
    • Google Drive
    • Google Search Console
    • Google Sheets
    • Hubspot
    • Import from API (Beta)
    • Local Files
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Shopify
    • Snowflake (Beta)
    • WooCommerce
    • Wordpress
  • 📈Sharing Data
    • Share Project with Collaborators
    • Share Public Project Link
    • Share Serverless SQL Warehouse
    • Build API Endpoint From Single Dataset
    • Share Dataset via Email
  • 🛠️Clean & Transform
    • Supported Data Types & Column Header Functions
    • Supported Clean Functions
    • Supported Transformations
    • Applying Existing or Shared Blueprints
  • 🌆Export Destinations
    • Airtable
    • Amazon S3
    • Dropbox
    • Google Drive
    • Google Sheets
    • MongoDB
    • MySQL
    • PostgreSQL
    • Redshift (Beta)
    • Snowflake (Beta)
  • Changelog
Powered by GitBook
On this page

Was this helpful?

  1. Data Sources

Google Sheets

PreviousGoogle Search ConsoleNextHubspot

Last updated 2 years ago

Was this helpful?

Phiona supports connections to Google Sheets through a native integration. When you first click on the Google Sheets button, a pop-up window will direct you to your different Google Accounts, where you can select the one in which you would like to connect.

Once you have connected to your Google Sheets account, you will see a list of Sheets links that you can access from your Google Drive. You will also see information on the owner of each sheet (you can access sheets that were shared with you) as well as the date the sheet was last opened. If you have many sheets, you can search for the sheet as well. Click on the sheet to connect to it.

If you have multiple tabs within a Google Sheet, each of the tabs will import as separate datasets in the project.

🔗
Select the Google Sheets icon under "Add New Data Set"
Enter your Google details to connect to Google Sheets