I want to automate the status update change in my Notion database
What have you tried so far?
I have the automation working successfully, however, I’ve missed something in that once it’s successfully completed it. The status changes from Awaiting A2A to Info Update.
What I mean is that, when I’ve received the A2A, the status then changes to the next phase of the process, however the system then resends the same email to the person who has already completed the A2A.
I was going to add an “exclude all these extra statuses” as a filter but I wondered if there was a smarter way to achieve the same thing.
Your automation is re-sending the email because the scenario keeps triggering even after the status moves past “Awaiting A2A,” so Make still sees the record before the update fully settles. Instead of adding a long list of excluded statuses, you can add one clean safeguard: only send the email when the status has just changed into “Awaiting A2A.” You can do this with a filter that checks the old status is different from the new one. Another option is to add a small “A2A Email Sent” checkbox in Notion and only send the email when that box is unchecked, then mark it as true afterward. Either method prevents duplicates and keeps the automation running only once per item.
@efficiencyisawesome It keeps resending it’s because your scenario only checks “Status: Awaiting A2A”. Every single time the item is edited or updated. It executes. So here’s what you can do about it.
Thanks guys, that has worked! I knew there was a better way to think about the problem. I’m still working through how I propose the logic conditions that make the most sense, but it was very satisfying to get it working.
Now I’m on to try and get an email address out of a google form - I’ve hit a few walls
You can pull emails or all the data from Google Forms. Ideally, you should have a Google Sheet ready with the specific headers or all the data headers that you need.
Module 1: Google Forms Module (Watch Responses)
Module 2: Google Sheet Module (Update a Row)
Map the values you want to add on each section or header in your Google Sheets.
Note: You can also use Tally as your form instead of Google Forms. It’ll be better based on my experience.
Ok, so if I understand correctly, this filter Send A2A must be met in order for the function work, so if that isn’t met, because it’s in a different stage, it won’t send at all?
We require more information that demonstrates the problem to help us reproduce the scenario and any issues and errors. This includes example output bundles from module [1] to verify that the variables in the filter are receiving the correct values.
Properly-formatted Output Bundles from a Scenario Run
Please provide the input/output bundles of each of the relevant modules by running the scenario, or get the bundles from a previous run from the Scenario “History” tab.
Providing the bundles from a scenario run will allow others to replicate what is going on, especially if there are complex data structures (nested arrays and collections) and external services. This helps mapping the correct raw variable names from collections (instead of the label/display name).
Need help❓View instructions ◀
Click on the white speech bubbles on the top-right of each module and select “Download output (or input) bundles”.
A. Upload a Text File
Save each bundle contents in a plain text editor as a moduleNumber-output.txt file. Open the file to check if it has not added additional formatting or encoded the plain text.
You can upload files and images to this forum by clicking on the upload button:
If you are unable to upload files on this forum, alternatively you can paste the bundles AND format them correctly.
Formatting IS Important!
Here are some ways to provide text content in a way that it won’t be modified by the forum.
Method 1: Type code fence manually —
Manually type three backticks ``` in a separate line before and after the content, like this,
```
text goes here
```
Method 2: Highlight the pasted content, then click the preformatted text/code button —
Method 3: Upload your file elsewhere and share the public link —
This method is only advised for large files exceeding the forum upload limit.
Sharing these details will make it easier for others to assist you, so that you can get better answers, faster. If you are still having trouble, please provide more details.
Signed A2A filter. Don’t use “does not exist” (the property almost always exists in Notion once it’s created), use something like is empty / is not checked / equals false. I hope that makes sense!
What is your goal?
What have you tried so far?
Formatting IS Important! 
