I am attempting to generate a Google Doc in a shared drive in our Google workspace. This works fine when I am having the Google Doc saved to my own Google Drive (the connected account is me). But when I attempt to pick a folder in a shared drive, I get the error:
Google reported an error while processing this action: Create Google Docs error
Is it not possible to write to anything other than your own Google drive?
Yep, that is weird. I haven’t also found a native way of overcoming that limitation.
However, it can be fixed with an external script. It would automatically trigger for all files that fall into a specified folder in your private Google folder and move them to the shared folder.
I can help with it if anyone is interested?
Unfortunately, Airtable chose to make its Document Automator / Google Docs feature not compatible with shared Google Drives at this time.
All of these products are significantly more powerful than Airtable’s Google Docs integration, since they can base documents off of advanced templates that you have already created.
Additionally, all of the above products can also create PDF document files that can get automatically inserted into Airtable’s Attachment Fields.