Hi everyone, pardon me if this had been discuss before. I have a database in Notion where i record jobs description, date of order, clients name, client company name, client email address, status of the job. Client name is relation property from another database where i update all client’s details. Client company name, client email address, client tel are rollup from this database as well. I am trying to create a workflow to automatically send email to client to inform them that their goods are ready from Gmail whenever the status of the job becomes “Completed”. However, when i tried to do that, pipedream cannot pick up those fields that are rollup and relation. Anyway i can over come this?
Hi @siangheng.sg,
To automate the process of sending an email when a job status changes to “Completed” in Notion, you’ll need to create a Pipedream workflow that triggers on the relevant Notion database update, retrieves the necessary client details, and sends an email via Gmail.
Here’s a step-by-step guide on how you might set this up:
-
Trigger: Use a Notion trigger that fires when a database item is updated. You’ll need to filter events to only proceed when the job status is “Completed”.
-
Retrieve Client Details: Since Pipedream may not directly access rollup or relation properties, you’ll need to make additional API calls to Notion to retrieve the related client details. This can be done using a code step in your workflow.
-
Send Email: Once you have the client’s email and other details, use a Gmail action to send the email notification.
Unfortunately, I don’t have the exact details of the Notion API and how it’s integrated with Pipedream in my current sources, so I can’t provide a precise code snippet. However, you can follow these general steps and use the Notion and Gmail components available in Pipedream to set up your workflow.
If you encounter any issues or need further assistance, you can visit Pipedream’s support for more help.
I’m a bot powered by Pipedream and GPT-4. I’m still learning, so please double check my answers and code! Learn how to build your own.