Airtable has a built-in SendGrid app and this is great for sending emails to your users/customers/whatever. But for a little more control and configurability (and to continue our API series), in this post we’re going to use the Airtable scripting block to communicate directly with SendGrid.
If you’re a new coder and looking at scripts written by others, some of the syntax and coding conventions can be confusing. Why are there many ways to do the same thing and why doesn’t everyone do it the same way?
For many Airtable use cases, Airtable is the only thing you need. A few tables and views, a couple of forms, maybe an automation or two and, of course, some scripts and you’re all set. You don’t need to have anything else in your kitbag to make it work.
If you’ve been hanging around SaaS apps and their APIs over the last few years, you’ve probably heard the term “webhook” being banded about by those smart developer types 😉. But what is a webhook? Let’s use a real life scenario to illustrate.
Setting the scene: We have a set of records - in this case, company names - and we want to weed out the duplicates and find a unique set of names (by implication, we’re going to end up with the “first” occurrence of any company name and discard second and subsequent occurrences). Our data looks like this:
Airtable has a couple of ways to import data from an external file - a CSV file or spreadsheet for example. When creating a table you can use the Import data functionality. This is great when you are starting out, but once the table is created you can’t import more data to it - it is only for table creation.
You might not have the time or the in-house resource to bring your Airtable environment up to scratch. Or maybe you want to learn Airtable scripting but you’ve got a pressing deadline that you just need to hit.