I have lots of zaps setup where I have a pdf upload into Google Drive, then in a subsequent step, I add the same pdf to an attachment field in Airtable. I could use the previous google drive step and find the “File: (exists but is not show)” for the Airtable Attachments field. Tonight, when attempting to do the same thing, I was forced to update to a newer version of the Google Drive step. Now I am no longer seeing this option for “File: (exists but is not show)”.
+14
Hi
You may want to try opening a ticket with Zapier Support: https://zapier.com/app/get-help
If you need a workaround, try using the direct download link for a file instead of the temp file object.
Tool to help you do that: https://sites.google.com/site/gdocs2direct/
Using the method you suggested, I was able to get a link into a URL field that will open the file (stored in Google Drive) directly from Airtable. However, I really need the document itself to be stored in Airtable and not google drive. As you’ve suggested, I’ve sent a help request to Zapier. Hopefully they can resolve my issues. I will follow-up on this post if they do. Thanks for your help.
+11
Hi there
Thanks for reaching out about this here. That definitely shouldn’t be happening! I’ve been looking into this on our end and it’s currently being investigated. I’ll follow up here once I have an update.
If I can help with anything else in the meantime please do let me know! 🙂
+14
Can you post updated screenshots with how your Airtable step is now configured?
You can use a publicly accessible direct download link for a file in an Airtable Attachment field and it will upload the file to Airtable.
Hello,
To save a bunch of time typing and a bunch of screenshots, I’ve made a Loom video trying to better explain the situation. Please watch the video by clicking the link.
Zapier to Google Drive PDF to Airtable & Gmail Integration Issue
Thanks.
Just received confirmation from another source that Airtable is currently experiencing issues storing and opening PDFs, which explains part of the issues explained in the video, but that issue still doesn’t explain the “File (exists but not shown)” issue.
+14
Believe Zapier has acknowledged a bug with the newest version of the GDrive app.
+11
Hi again
Following up here as promised to report that our engineers have shipped a fix for the issue with the missing File field. It will now contain a URL for the file in the File field instead of showing as (Exists but not shown) - but it will function the same. 😁
Can you check the Zap again and confirm whether that File field is now available to select from the Upload File action?
Thanks again everyone for your prompt attention.
Yes, it appears someone has been working on the issue because there is a new option in the G Drive step that wasn’t there yesterday / this morning.
Using the “File https://zapier.com/engine/hydrate/…..” found in the Google Drive step, I was successful in delivering pdfs as attachments for outbound Gmails. So in that regard, it is working. However, the pdf is named exactly the same as the folder in which the file was stored (which leaves a lot to be desired). Ideally, the attachment would be named exactly the same as the one stored in the G Drive folder.
As far as Airtable, I believe this in an issue within their system, but it may be related. I’ll just have to wait and see if Airtable acknowledges the issues. I’ll follow up if/when they do. Thanks.
From Airtable support: “Airtable is experiencing some issues with PDF attachment processing and our engineering team is already working on fixing the issue. We hope to have a resolution soon and we will keep you posted. Sorry for the disruption.”
+11
Thanks for the updates here,
I’m so pleased that you were able to select the new File field and it worked. 🎉 And I’m really glad that Airtable were able to confirm that there is an issue with processing PDF files which will be resolved soon. Hopefully once that’s been sorted the Zap will then be running correctly again. 🤞
Please do keep us in the loop on how it goes, keen to ensure you’re all set!
Airtable has resolved the issue. PDFs adding to AT as they should now. Thanks again.
+11
YAY! That’s great news
Please do reach out in the Community again if anything else pops up - we’re always here and happy to help!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
