Yes, I’ve done very similar automations. For example, build a rich text status report in a Google Doc, convert to PDF, and email automatically every morning. Doing this with Google Slides is almost an identical approach - the Google Docs SDK for creating slide content is the same for creating documents.
If you need some more guidance, feel free to reach out - email@example.com.
I’ve used the Zapier (zap) to do this and it is certainly possible to generate slides without writing any code. However, there are two key issues -
There is a 1-to-1 relationship between records in Airtable and slides in the zap integration; it’s basically like a mail merge but with slides instead of messages. This is not always the desired output or logical format for the data, but it certainly is fine for simple integrations.
Pumping Airtable data into Google via templates which create new documents in Drive is typically not the end of the desired reporting automation process. Emailing, sharing (through Google’s security model), bundling into PDF form, and other aspects of reporting still [may] need to be performed. I get the sense that this person wants a “lights out” process that runs even when sitting on a beach.
Indeed, avoiding code is always best and even better - create good business requirements in advance of choosing any specific implementation approach.
I have stumbled across your post and I was wondering if you were able to help me out. We are looking for a solution to automatically transfer certain fields in our Airtable base to a pre-defined Google Document, i. e. if a new member of our NGO registers with us we want to automatically create the letter/certification of membership rather than copy-pasting all the individual details such as name and address.
Would you be able to give us some tips how to approach this?
thanks a lot