Author: Ashok Dasineni

In this post, we demonstrate how to enable and configure Google Sheets as a new data source in Amazon QuickSight, including the required AWS Secrets Manager Write permissions setup and OAuth authentication process. Learn how to securely connect QuickSight to Google Sheets data, allowing you to transform spreadsheet data into powerful analytics and visualizations using QuickSight’s business intelligence capabilities.

AWS PrivateLink interface VPC endpoints provide private connectivity between a QuickSight website, VPCs, or on-premises networks without exposing traffic to the public internet. Traffic between the VPC and the website doesn’t leave the Amazon network, and all communication between the VPC and the website is kept private within AWS, making sure the data in QuickSight is kept secure. Administrators can also use VPC endpoint policies to restrict access to QuickSight accounts that are not authorized on their network. In this post, we show how to establish end-to-end private connectivity from users on premises to a QuickSight website using VPC endpoints and AWS Direct Connect.