Email exported csv from Snowflake query

Hi @ariq 

Review the available triggers/actions and help links for each Zap app:

• Snowflake
  • https://zapier.com/apps/snowflake/integrations#triggers-and-actions
  • https://zapier.com/apps/snowflake/help
• Outlook
  • https://zapier.com/apps/microsoft-outlook/integrations#triggers-and-actions
  • https://zapier.com/apps/microsoft-outlook/help
• Schedule
  • https://zapier.com/apps/schedule/help

Hi there @ariq 👋

How are things going on this? Were you able to get the desired workflow set up between Snowflake and Outlook by using Schedule by Zapier for the trigger? 

For the generating the CSV itself, I wanted to suggest looking at using an app like EasyCSV which has an action to generate a CSV file.

Alternatively, you could have the Zap generate a new spreadsheet in Google Sheets, add the data from Snowflake to it, a Google Drive Find a File action could be used to get the CSV version of the spreadsheet (File CSV field). Or you can generate the file link as mentioned here: 

Then, you’d select the link to the CSV version to be added as the email’s attachment. 

If you’re getting stuck at all or have found a different solution please do let us know! 🙂

Hi @SamB !

Jumping in as I have a similar issue! I’d like also to have a csv of my snowflake query. Would the good flow be:

• Trigger
• Snowflake Execute SQL
• Create csv via EasyCVS

Thanks :)

Hey @Edoardo, thanks for reaching out here! 🙂

Yes that sort of approach that should work. Let us know if you run into any issues on setting that up, happy to assist further!