Eliminate external ETL tools. Learn how to use Python Stored Procedures and External Access to pull Gmail attachments into Snowflake stages.

Snowflake Community is a platform for users of the Snowflake cloud data platform to share knowledge, ask questions, and collaborate. Readers can learn about cloud data warehousing, data analytics, and data engineering best practices. With forums, user groups, and community events, Snowflake Community provides resources for Snowflake users to connect and learn from each other.

Snowflake Community

Learn how to pull Gmail attachments and Google Sheets data directly into Snowflake using Python stored procedures and External Access integrations. The tutorial covers setting up Google service accounts with domain-wide delegation, configuring Snowflake network rules and secrets, and building a stored procedure that authenticates with Gmail, searches for messages with attachments, and downloads matching files to Snowflake stages for processing with COPY INTO, Cortex AI, or Snowpark UDFs.

Reading Gmail Attachments or Google Sheets Directly Into Snowflake

Now let’s set up everything we need in Snowflake

What about similar applications, for example Google Sheet?