I know this issue has been discussed before, but there doesn’t seem to have ever been a solution discovered, so I’m bringing it up again in case anyone’s found an answer in the last 1.5 years.
The problem: occasionally/often, when an attachment is uploaded to Airtable via a Make.com automation, Airtable will immediately delete the file after upload. In the record history, it will say that the user who created the record also deleted it, but that’s not the case.
@maradas Why do you have the download module in there? Assuming that your upload module is successfully uploading the files to your Google Drive (have you checked to see if the attachments are actually in your Google Drive?), then you only need to get a share link from the upload module. It should look like the screenshot below:
@maradas Additionally, the most important thing of all is that you have to make sure that you are uploading to a publicly-accessible folder that any user on the Internet can access. You can’t upload to a private folder.
Hello @ScottWorld ! The Download module was an extra module that I’d forgotten to delete, but nothing was actually pointing to it, so it had no impact on the rest of the automation. Additionally, yes the Google Drive file was publicly accessible, and the files were successfully downloaded into it.
However, you actually ended up pointing me in the right direction–after I deleted the superfluous Download module, I started looking at the Delete File module at the end, and disconnected it from the flow to test things out. That actually seems to have fixed the error; I tested it with ten different emails, and all were able to upload attachments successfully.
I don’t have a good idea about why that might be–maybe the files being deleted from Google Drive while subsequent files were getting uploaded meant that the “host” file no longer existed while the upload hadn’t fully been processed? But getting rid of that module seems to have solved the issue! So thank you :slightly_smiling_face:
That is correct… you need to give time for Airtable to download the attachment. It doesn’t happen instantly. So it sounds like you were deleting the file before Airtable even had a chance to access it.
This is a known issue - Airtable uses the service Filestack in processing attachments, Google Drive at times IP address rate limits downloads from Filestack, which causes transient failures like those observed here.
When this happens Airtable will write a log of the file before it is actually downloaded, when the download fails the record logs will look like the user uploaded and then deleted the file.
I have had this happen numerous times across many different automations and use cases when downloading from Google Drive. Switching to a different provider solves the issue.
Depends… WIth Make not being able to transfer files to airtable without a public URL I use Digital Ocean spaces product which is 5$ a month. They have a Make app. Its similar to amazon s3 but simpler in every way… I send file payloads there, and grab the public url to send to Airtable.
This solution is good if people are using Google Drive basically as a Public URL file cache for Airtable.
Yes it is a know issue, I have made a video about a workaround some time before. You basically use can use Make webhook as an upload URL … - the webhook downloads the file from Drive and returns as data in webhook response. In Airtable attachment upload field you use webhook url with Google File ID.
This is a known issue - Airtable uses the service Filestack in processing attachments, and Google Drive at time rate limits downloads from Filestack, which causes transient failures like those observed here.