Airtable search records gmail zapier update#

Its UX is world-class, and thanks to an integration with other Google tools, it can skyrocket your productivity.

Build Powerful Business Workflows with Gmail and ZapierĪs an email client, Gmail offers a host of features that make managing emails a breeze.

Save New Gmail Attachments to Google Drive Save Gmail Messages to Google Sheets with Zapier Use Gmail Zapier Integration to Send Emails to Slack Create Zapier Workflows with Airtable and Gmail

Combining Zapier with Gmail Filtering and Labels.

Some scenarios more easily than others, perhaps, but all are well within the abilities of the integration. However, the answer to your question remains ‘yes’: It can be done with Airtable and Zapier. Likewise, if both the invitation and your base contain blocks of multiple email addresses, identifying the correct record can become tricky - especially if an individual email address can be a member of more than one block.

Airtable search records gmail zapier update#

For instance, if your invite contains, say, five email addresses, and your base is organized by individual, you’ll need a mechanism in Zapier that allows you to loop through the recipient addresses, isolate each email address, search for it in Airtable, and update records applicably. It’s triggering on the email’s being sent that has potential for introducing hair - again, largely depending on table structure. If the record contains multiple email addresses, the search becomes a little more complicated you’ll probably want to use a search formula to find the record. If the Airtable base contains one person per record, it’s extremely straightforward: Once Zapier triggers, you search for the Airtable record with an email address matching that of the response sender and update it.

For instance, if you’re sending out invitations, and you want Zapier to trigger on receipt of a response from one of the individuals on the email list, that’s pretty straightforward. It potentially gets a little hairier depending on the exact process flow. That’s actually a very different use case than the first poster was facing, but, yes, it should be possible to do it with help from a SaaS integration service such as Zapier.

There could certainly be other ways to approach this problem - in fact, I fervently hope there are, and that some clever soul posts a more attractive alternative to these two.

I can’t point to any reference off the top of my head of someone doing the same thing as you, but you can find very similar routines in a number of my other community posts and replies. (You may have to tweak some of those offsets a bit, as I’m freestylin’ here with no way to check for accuracy.) Your best bet is probably to create a table (or modify your existing one) to list contacts keyed by email address and have the Acuity Zap enter the retrieved email into a linked field.Īlternatively, you can link every record to a single record in a new table I’ll call create a new field in containing a key:value pair consisting of roll up all of the key:value pairs into a single concatenated string in using '|'&ARRAYJOIN(values,'|') as the aggregation formula and, finally, search the concatenated string for the retrieved email address and, if found, extract the contact name, using an aggregation formula similar to this: IF( You’d be surprised how not straightforward it is. This seems really straightforward so perhaps i’m missing something obvious.