Send automated bulk emails with SendGrid and Retable
We’re super excited to introduce our latest integration with SendGrid, bringing you powerful email automation directly within Retable! 🎉
With this new feature, you can now easily send personalized emails from your Retable projects, streamlining your communication workflows and reaching your audience effortlessly. Whether it's promotional campaigns, updates, or automated notifications, our SendGrid integration allows you to manage your email communication without leaving Retable.
1. Access your project: Open the Retable project that contains the email addresses of the people you want to send emails to.
2. Go to automations: In the top right corner of your project, navigate to the "Automations" section.
3. Create a new automation: Click "Add New" to create your new automation.
4. Name your automation: Provide a name for your automation in the "Name" field.
5. Set your trigger: Select the type of trigger that will activate the automation.
6. Choose your table: Select the table that contains the email information you’ll be using.
7. Select "Send email with SendGrid" as action: Choose "Send Email with SendGrid" as the action type.
8. Create a SendGrid connection: Click on the "New connection" button to create your SendGrid connection.
9. Name your connection: Give your connection a name. Optionally, you can add a description.
10. Enter SendGrid API Key:
In the API Key field, enter your SendGrid API key.
You can use the same API key for multiple automations.
11. Save your connection: Click the ‘Save’ button to store your SendGrid connection. You can add multiple connections if needed. Please note:
Connections are user-specific, meaning other users in the project can’t edit your connections.
You can see and use connections added by others if they are selected for an automation, but you can’t see or edit connections not selected by other users.
12. Select your "From" email address: After saving, the email addresses registered with your SendGrid account will automatically be listed in the From field of your automation. Select the email address you want to send your emails from.
13. Specify recipients (To field):
If your table has an "E-mail" column, you can use curly brackets `{}` to reference the column name in the ‘To’ field. Example: `{E-mail}`.
This ensures that emails are sent to the email addresses in that column when the trigger is activated.
Alternatively, you can manually enter email addresses in the ‘To’ field if you want to send emails to the same recipients each time. To send emails to multiple addresses, separate them with commas.
14. Write your email content:
In the ‘Content’ field, write the email message you want to send. If you wish to pull data from a specific column, use curly brackets `{}` to reference the column name.
For example, if you want each email to include the recipient’s name and your table has a "Name" column, you can write `{Name}` in the content field. This will automatically personalize the emails with each recipient’s name.
15. Use a dynamic template (Optional):
You can also activate the ‘Use Template’ button to select one of the dynamic templates available in your SendGrid account. If you wish to pull data from a specific column, use curly brackets `{}` to reference the column name.
For example, if your SendGrid template has a variable called "userName" and you want to dynamically pull the "Name" values from your Retable table, after selecting your SendGrid template using the "Use template" option, simply enter "userName" in the Name field for the SendGrid variable and add your Retable column name in the Value field, using curly brackets like this: {Name}.
Additionally, you can assign fixed values to variables defined in SendGrid directly from Retable. You can set a constant value instead of dynamically pulling data from your Retable columns. For example, if you have a variable named "couponCode" in SendGrid, you can enter "couponCode" in the Name field and input a fixed coupon code value in the Value field. When doing this, you should not use curly brackets.
Now your automation is set up! When the selected trigger is activated, your email will be sent automatically through SendGrid. 🚀
🎯 Discover how effortlessly you can elevate your data management experience with Retable: https://app.retable.io/