Hi everyone! I’m working on an automation where I send emails and want to track the status in a spreadsheet. Here’s what I need help with:
- When the email is successfully sent, the “Status” column in the sheet should be updated to “Sent”.
- If the email bounces, the status should be updated to “Bounced”.
- If the email fails to send due to an error, the status should reflect the specific error message (e.g., “Invalid email format”, “SMTP error”, etc.).
If anyone has done something similar, could you please guide me on how to structure this in Make.com ? Would love any guidance or examples!
Also, if possible, please help me with a sample JSON file or webhook structure that I can start testing with. ?