Sep 21, 2020 09:50 AM
All,
I’m trying to import a file doc file that exists in an airtable attachment field into Google Drive in integromat.
So it actually creates a file, by the name that I have assigned. But when you open it, here’s what it looks like:
You’ll notice first that it doesn’t open in editor. And what you are able to make out of the text is the address of the file in airtable (according to airtable).
As far as the setup in Integromat, here’s what the settings look like:
Solved! Go to Solution.
Sep 21, 2020 09:57 AM - edited Jun 21, 2023 04:21 AM
Attachments are stored as a URL in Airtable, so your Integromat setup is currently only sending the URL onto Google Drive, not the actual attachment file itself.
In Integromat (now known as Make), you need to add an additional module to convert the URL into an actual file.
That would be the HTTP module, and you would choose the “Get A File” function. (See screenshot below.)
Then, you would send the results of THAT module onto Google Drive.
p.s. If you have a budget for your project and need to hire an expert Airtable consultant to help you with any advanced automations, please feel free to contact me through my website! 🙂
Sep 21, 2020 09:57 AM - edited Jun 21, 2023 04:21 AM
Attachments are stored as a URL in Airtable, so your Integromat setup is currently only sending the URL onto Google Drive, not the actual attachment file itself.
In Integromat (now known as Make), you need to add an additional module to convert the URL into an actual file.
That would be the HTTP module, and you would choose the “Get A File” function. (See screenshot below.)
Then, you would send the results of THAT module onto Google Drive.
p.s. If you have a budget for your project and need to hire an expert Airtable consultant to help you with any advanced automations, please feel free to contact me through my website! 🙂
Sep 21, 2020 10:30 AM
Thank you! That did the trick
Sep 21, 2020 10:45 AM
Fantastic! Glad I could help! :slightly_smiling_face: If you don’t mind, could you please mark my comment above as the solution to your question? This will help other people who have a similar question in the future. :slightly_smiling_face:
Sep 23, 2023 03:05 AM
Hi Scott,
Busy trying your solution but it doesn't work for me. Still showing the url and not adding the file. Any ideas as to why?