Streamlit in Snowflake Google Sheets Connector

Looking for an easy way to get Google Sheets data into Snowflake? I've created a sample Streamlit in Snowflake app which does exactly this, allowing business users to load Google Sheets data to a Snowflake table without writing a single line of code.

The app uses Streamlit in Snowflake (PuPr on AWS at the time of writing) and External Access (PuPr on AWS and Azure at the time of writing) to fetch data from a Google Sheet via a Snowpark Stored Procedure that uses the gspread python library.

The code and setup instructions are available from my github repo here and I’ve recorded a short demonstration of it in action below.

Enjoy!