Creating a dataset using a Google Sheets data source - Amazon QuickSight
Admin configuration in Amazon QuickSightCreating a dataset using a Google Sheets data source
Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

Creating a dataset using a Google Sheets data source

Google Sheets is a web-based spreadsheet application that enables users to create, edit, and collaborate on data in real time. With its comprehensive set of functions and formulas, it serves as a powerful data source for business intelligence and analytics. Users can organize, analyze, and share insights efficiently, while its seamless collaboration features make it an ideal platform for teams working on data-driven projects.

Admin configuration in Amazon QuickSight

Amazon QuickSight administrators need to perform a one-time setup to enable Google Sheets as a data source. For detailed instructions and important considerations, see the blog.

Creating a dataset using a Google Sheets data source

Use the following procedure to create a dataset using a Google Sheets data source.

To create a dataset using a Google Sheets data source

  1. From the Amazon QuickSight start page, choose Datasets.

  2. On the Datasets page, choose New Dataset.

  3. In the FROM NEW DATA SOURCES section, choose Google Sheets.

  4. Enter a name for the data source, and then choose Connect.

  5. When redirected to Google's sign-in page, do the following:

    1. Enter your Google account credentials, and then choose Next.

    2. Review the permissions to authorize your Amazon account to connect with Google Sheets, and then choose Continue.

  6. In the Choose your table menu, locate your data. The menu displays all folders, subfolders, sheets, and tabs from your Google account. To display the tabs, select a sheet from the displayed list.

  7. Select the tab you want to work with.

  8. Choose Edit/Preview data to navigate to the Data preparation page. Choose Add data to include any additional tabs.

  9. Configure the join, and then select Publish & visualize to analyze your Google Sheets data in QuickSight.

Note

  • This connector supports only SPICE functionality.

  • If your OAuth token expires (visible in the ingestion error report or when creating a new dataset), reauthorize by choosing Edit on the data source and updating it.