How can I send initial and follow up emails to multiple emails?

Set Up Google Sheets:

• Your Google Sheet should have at least the following columns: Email, Name (optional), Initial Email Sent (YES/NO), Follow-up 1 Sent (YES/NO), Follow-up 2 Sent (YES/NO), Follow-up 3 Sent (YES/NO).

Create Zaps in Zapier:

a. Initial Email:

• Trigger: Set the trigger to "New Row in Google Sheets". Select your sheet and the worksheet.
• Action 1 (Gmail): Choose Gmail's "Send Email" action. Map the email column from Google Sheets to the "To" field in Gmail. Craft your initial email content.
• Action 2 (Google Sheets): Update the row in the sheet to change the "Initial Email Sent" column to "YES".

b. Follow-up Email 1:

• Trigger: Use the "Updated Row in Google Sheets" and set up a filter where the "Initial Email Sent" is "YES" and "Follow-up 1 Sent" is "NO".
• Action 1 (Delay by Zapier): Set a delay for when you want the first follow-up to be sent.
• Action 2 (Gmail): Choose Gmail's "Send Email" action and craft your follow-up email content.
• Action 3 (Google Sheets): Update the row in the sheet to change the "Follow-up 1 Sent" column to "YES".

c. Follow-up Email 2 & 3: Repeat the process for the subsequent follow-up emails, adjusting the delay and filters accordingly.

Test Your Zaps: Before fully automating, make sure to test your Zaps to ensure that the emails are sent correctly and the sheet updates as intended.

Activate Your Zaps: Once tested, turn on your Zaps. When a new row is added to the Google Sheet, the initial email will be sent, followed by the follow-up emails based on your set delays.

@brandsbybrie try the above one 👆🏻