<aside> ⚠️ DEPRECATED!!! This guide migrated to our docs. Please view the current version at: https://docs.streamlit.io/en/stable/tutorial/private_gsheet.html
</aside>
This guide explains how to securely access a private Google Sheet from Streamlit sharing or Streamlit for Teams. It uses the gsheetsdb library and Streamlit's secrets management (requires streamlit v0.80.0 or higher).
<aside> ☝ If you are fine with enabling link sharing for your Google Sheet (i.e. everyone with the link can view it), the guide Connecting Streamlit to a public Google Sheet shows a way simpler method of doing this. If your Sheet contains sensitive information and you cannot enable link sharing, keep on reading.
</aside>
<aside> 🏃 If you already have a Sheet that you want to access, feel free to skip this step.
</aside>
Programmatic access to Google Sheets is controlled through Google Cloud Platform. Create an account or sign in and head over to the APIs & Services dashboard (select or create a project if asked). As shown below, search for the Sheets API and enable it (double click on images to enlarge):
To use the Sheets API from the Streamlit Cloud, you need a Google Cloud Platform service account (a special account type for programmatic data access). Go to the Service Accounts page and create an account with the Viewer permission (this will let the account access data but not change it):
<aside> ☝ If the button CREATE SERVICE ACCOUNT is gray, you don't have the correct permissions. Ask the admin of your Google Cloud project for help.
</aside>
After clicking DONE, you should be back on the service accounts overview. First, note down the email address of the account you just created (important for next step!). Then, create a JSON key file for the new account and download it:
<aside> 🤫 Store the key file in a safe location and don't share it with anyone.
</aside>