I've generated a Google Doc from a template using the "Create a Document from a Template" module in callin.io. The data for this document originates from a stock market API, and each document contains a summary of the data retrieved from the API service.
My objective is to transfer this Google Doc into an Airtable attachment field as a PDF. The corresponding Airtable record would reference the same stock symbol as the Google Doc, and this specific Airtable record is linked earlier in my callin.io sequence.
I'm encountering an issue where Airtable doesn't easily map the Google Doc from the Google Docs module "Download a Document." I have configured my Google Doc to download as a PDF.
When I attempt this with other applications, including Slack, Dropbox, Google Drive, and OneDrive, the mapping is straightforward. However, with Airtable, it displays the output from the "Download a Document" module as the filename I assigned to the Google Doc, followed by a field named "Data" containing a long string of alphanumeric characters. Airtable fails to recognize this string, resulting in an error within callin.io that requires a file URL for uploading the PDF.
I've attempted to use the "content download URL" data field from the source Google Doc, but I consistently receive an error related to access permissions. This is because the Google Doc is not publicly shared, and as I understand it, Airtable requires a public URL to access the file.
I've been employing a workaround that involves uploading the downloaded Google Doc to OneDrive. From there, it maps easily, and I can then manually map the OneDrive file to the Airtable attachment field. While this method is functional, I'm looking for a more streamlined process that avoids downloading the document, uploading it to a secondary service, and then retrieving it from that service to import into Airtable.
My primary question seeking an answer is:
_Is there a more efficient method to map files from the Google Docs "Download a Document" module to an Airtable data field using the Airtable "Update a Record" module?
This setup involves a paid Google Workspace account, a paid OneDrive for Business account, and the Airtable Business plan.
Hello there!
Welcome to the callin.io Community.
If you're looking for a download link for any documents, they need to be uploaded to Google Drive.
Simply creating a document doesn't mean it's uploaded to Drive.
Just downloading the doc file won't work in this context.
First, create the document, then upload it to GDrive. After that, the export=download link should function correctly for uploading to Airtable.
Thanks,
Sachin Shrivastava
This solution was effective. I sincerely appreciate your help with this matter.
Hello there!
Glad to know I could assist you.
Please ensure you mark my answer as the solution. This will help other community members if they encounter a similar issue in the future.
I have completed that. Thank you!