Help

Adding attachments from Google Docs/Sheets/Drive via Airtable API can result in corrupted files

Topic Labels: ImportingExporting
Solved
Jump to Solution
351 4
cancel
Showing results for 
Search instead for 
Did you mean: 

Hello there,

I’m using Make / Integromat to create Google Docs and upload them as PDFs to Airtable. Occasionally this results (without obvious reasons) in broken PDF files. While the file name is correct, they’re missing a preview, open as blank and are read corrupted in external PDF apps.

image

The automation completes successfully. If I open the Google Docs PDF export link, the PDF comes out alright. This makes me think the PDF file breaks while being imported to Airtable.
image

Is there a known error, fix or workaround to this? I can’t find an indicator to tell the system the file is corrupted (still has regular file size) to let it redo it automatically.

Thanks for your input

1 Solution

Accepted Solutions

Airtable support confirmed that there is a known issue when uploading Google URLs via the API.

For more context, Airtable uses the service Filestack in processing attachments, and Google Drive limits downloads from Filestack, which causes transient failures like those observed here. Unfortunately, the scope of work required for resolving this issue is quite significant and involves the other platforms, and we do not at this time have a concrete timeline for when this will be resolved. I’m really sorry about this.

As these limitations appear to be Google specific, you can also try storing the files with a different file hosting service (such as Dropbox), since we have not encountered this issue with other file hosting services. I know that isn’t an ideal workaround especially if Google Docs is a core part of the workflow in that it is used to actually make the docs, and I’m sorry I don’t have a better solution at this time!

See Solution in Thread

4 Replies 4

Are you sending the “web content link” from Google Drive into Airtable?

You’ll also need to have the proper permissions set for your Google Drive folder as well.

Thanks and almost, I’m using the Export:PDF link of the Google Docs module. The Drive step is to manage the sharing settings / permissions of each file.

In general it works fine, but while there was once one corrupt PDF in say a hundred, yesterday it shot up to every third or fourth.

Opening the export link in the run history, the correct PDF is download in an incognito browser, the output and sharing settings are seemingly fine.

I would try the “web content link” and see what happens.

Airtable support confirmed that there is a known issue when uploading Google URLs via the API.

For more context, Airtable uses the service Filestack in processing attachments, and Google Drive limits downloads from Filestack, which causes transient failures like those observed here. Unfortunately, the scope of work required for resolving this issue is quite significant and involves the other platforms, and we do not at this time have a concrete timeline for when this will be resolved. I’m really sorry about this.

As these limitations appear to be Google specific, you can also try storing the files with a different file hosting service (such as Dropbox), since we have not encountered this issue with other file hosting services. I know that isn’t an ideal workaround especially if Google Docs is a core part of the workflow in that it is used to actually make the docs, and I’m sorry I don’t have a better solution at this time!