Email management with SendGrid is impossible

When you use the SendGrid extension, Airtable does not store the fact that you sent an email. If you continue to use the SendGrid extension, you will need to somehow manually record which emails were sent to which people.

Can you share screen shots explaining your difficulty in using the "Manage Extensions" window/panel, even when it is full screen? You should be able to make the entire "Manage Extensions" panel full screen and/or an individual extension full screen. Either method should make the full titles of extensions visible. You can also organize different extensions into different dashboards to make it easier to find the exact extension you want. You can also manually drag extensions around within a dashboard to re-order them.

The sorting logic for picking a view in an extension depends on how the extension was written. It might use the default sort order provided by Airtable, or it might have some other sort. The sort order might be the order in which the views were created, or it might be the order in which views appear in the views panel on the left.

Some food for thought:

- Do you want to use a template that you maintain in Airtable, or a template in your email campaign provider?

- Do you want to track which emails have been sent in Airtable or in your email campaign provider?

If you want to track which emails have been sent in Airtable and also maintain templates in Airtable, you could use a system where you create linked record of individual emails, with one record for each combination of recipient and merged message. Then you could have SendGrid (or another service) actually send the email.

I am picturing an [Email Templates] table, and an [Emails] table, to go with your [Workers] table. The [Email Templates] table would hold email templates in a long text field. the [Emails] table would have junction records between the [Email Templates] and [Workers]. The merged contents for the message could be created via scripting, or with formula fields with lots of nested SUBSTITUTE() formulas. You could use scripting or automations to create the junction records.

The [Emails] junction table should also have an editable field for indicating if an email has been sent or not, such as a date field for when the email was sent. If you use an automation integration, the automation can check for new, unsent emails, send them, and then mark them as sent. If you use the SendGrid extension instead of an automation, you will point the SendGrid extension to the view of unsent records. Then, after you send the emails, you will need to manually mark the email records as sent.