Scenario Help Needed: Email Sending & Status Update in Sheet

[Khateeb]

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. ?

[samliew]

Welcome to the Make community!

I would suggest completing the Make Academy before jumping into building a complete scenario. If you need specific assistance when you are building a scenario it’s easier to help you then. Otherwise, you can also hire a professional by posting a request in the Hire a Pro category.

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

• Help Centre | Tutorials – Make “Manual” - search for help here first
• Make Academy – Basics 101: Learn Make properly to get your money’s worth

Help Centre Basics

• Mapping – What is mapping? What can I map?
• Mapping with arrays – How to map items in an array
• Aggregate an array for mapping complex fields
• Date Format: tokens for parseDate | tokens for formatDate
• HTTP modules – Make a request, Get (download) a file
• Webhooks – Error Handling, Responding to webhooks

Articles & Videos

• Router Magic Formula - YouTube
• Error Handlers in Make - YouTube playlist
• Getting started with OpenAI - How to setup and use OpenAI (ChatGPT) in Make
• Text Parser module - Use pattern matching to extract the text you want
• Webhooks – Make Academy – tutorial on how to use Webhooks

Hope this helps! Let me know if there are any further questions or issues.

— @samliew