Automatically combining records into one email

[Katherine_McLai]

I would like to take participants’ responses to an Airtable survey, create a visualization of them, and send the graphic via email. There will be a lot of participants who complete the survey, so I would like to automate this process.

The goal is that:
(1) a participant completes the survey
(2) a graphic is automatically generated from their unique survey responses
(3) this graphic is automatically sent to that specific participant via email.

Is there a way using to configure this within AirTable such that a unique graphic is generated automatically based on a participant’s survey responses and that this unique graphic is sent to them automatically via email?

[ScottWorld]

Welcome to the community, @Katherine_McLain!

You can’t natively automate the creation of a graphic and then email it within Airtable, but you could automate the graphic creation with the help of external tools, and then you could automate the entire creation/emailing process by writing your own custom JavaScripts or by using an external automation tool such as Integromat.

First you would need to choose what tool you want to create your graphic or document in. Some popular choices are:

• DocuMint, which comes with a companion Airtable app, or can be automated via scripting or a no-code/low-code automation tool like my personal favorite Integromat:

Documint

Documint - Document automation for productive people

Documint empowers businesses and individuals to automate everyday tasks using document generation to increase productivity.

• APITemplate.io, which can be automated via scripting or Integromat:

Integromat

APITemplate.io Integrations

APITemplate.io allows you to auto-generate images and PDF documents with a simple API

• Bannerbear.com, which can be automated via scripting or Integromat:

Integromat

Bannerbear Integrations

Bannerbear is a service that automatically generates variations of graphic templates.

• Google Slides, which can be automated by scripting, Integromat, or On2Air: Amplify:

On2Air | Accomplish Anything with Airtable – 16 Jun 21

On2Air: Amplify | On2Air

On2Air: Amplify is record editor and viewer. Create custom records by displaying or hiding fields, view documents or attachments in full-screen, and edit current records or create new records directly from the dashboard. On2Air: Amplify is an...

Integromat

Google Slides Integrations

Integromat gives you the ability to integrate Google Slides with many other services.

If you didn’t need the process automated at all, you could manually generate the graphic by using Airtable’s Page Designer.

p.s. This can all be a little bit tricky if it’s your first time doing it. If you have a budget for this project and you’d like to hire an expert Airtable consultant & Integromat Expert+ Partner to help you create this, please feel free to contact me through my website at ScottWorld.com:

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable Consulting,...

ScottWorld • Best Airtable Consultants, Airtable Experts, Airtable...

ScottWorld provides the world's best Airtable consultants, Airtable experts, Airtable developers, FileMaker consultants, and Airtable trainers. Airtable consulting, FileMaker development, and Airtable training.

[Katherine_McLai]

@ScottWorld Thank you for your response! You mentioned that it might be possible for me to automate the creation/emailing process using custom JavaScripts. Is this something that would be possible using Airtable scripts? If I understand correctly, these run on JavaScript.

[ScottWorld]

Right, scripts means JavaScript.