Hello,How I can create this automation?.Every friday I have to send an email to each customer with their pending invoices to pay.The list of the invoices coming from an SQL query with the following fields:Customer ID Customer email address Customer name Invoice number invoice date Invoice URL Invoice amountSo I’m imagining create a zapier doing:Step 1: run zapier every friday (with schedule trigger) (DONE) Step 2: Run SQL query (DONE) Step 3: Process data and group invoices by customer (I need help with this) Step 4: Prepare an email by customer (Something like a loop?) with a the list (could be a table on the email body) with the list of the invoices and detailsI hope anyone can help me with this, I will appreciate it.

Question

Send weekly customer email with their pending invoices list coming from a snowflake sql query

Hello,

How I can create this automation?.

Every friday I have to send an email to each customer with their pending invoices to pay.

The list of the invoices coming from an SQL query with the following fields:

So I’m imagining create a zapier doing:

Step 1: run zapier every friday (with schedule trigger) (DONE)
Step 2: Run SQL query (DONE)
Step 3: Process data and group invoices by customer (I need help with this)
Step 4: Prepare an email by customer (Something like a loop?) with a the list (could be a table on the email body) with the list of the invoices and details

I hope anyone can help me with this, I will appreciate it.

This post has been closed for comments. Please create a new post if you need help or have a question about this topic.

Userlevel 7

+14

Hi @Leonardo.Palacio

Step 3 may require using a custom Code step: https://zapier.com/apps/code/help