Aug 07, 2019 11:52 AM
I plan all of my content in Airtable with detailed notes but my creative teams prefer Google Docs. Is there a way to automatically populate a multi slide brief in Google Docs?
Aug 09, 2019 11:51 AM
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 - firstname.lastname@example.org.
Aug 10, 2019 09:16 AM
This could probably also be done without scripting by using Zapier. It has a Google Slides action named “Create presentation from template” which might do the trick. I’ve not used it before, so I can’t offer specific advice about how to set it up, but my gut says it would work.
Aug 10, 2019 11:01 AM
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.
May 23, 2021 03:51 AM
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
Jul 10, 2021 02:37 PM
Sorry, just saw this. No. :winking_face:
Seriously slammed lately. Aren’t there some pretty new products that have come forth to do this in Airtable like this one? Take a look at this.
Jul 10, 2021 03:05 PM
You can also checkout out On2Air - we just added support for Google Docs/Sheets/Slides to auto populate from an Airtable Record.
Jul 11, 2021 04:43 AM
thanks a lot Bill! we’ll take a look at that, it seems to a handy product
Jan 02, 2023 02:12 AM
Thats cool. But where is it. You've disabled this product on your website... Why? When is it out of Beta?