Thanks for doing this video - was hoping it was just what I needed, but I have tried several things - and for some reason, my second Make scenario does not receive the webhook from the Airtable module in the previous scenario. It works when testing (sometimes) - but when used in anger it just sits waiting for the hook to arrive. Maybe something has changed on the Airtable end since this video was produced?
It works, try maybe adding &time={{now}} (or similar with {{now}} being a time variable now() from Make) this will prevent Airtable caching the URL - means if you request same URL multipe times Airtable might hold the cached version from previous request.
Thanks so much! I have (sort of) got it working. It was my user error. Followed your instructions and all (almost) working. Thanks! The issue I have though is that the PDF shows in Airtable and clicking it opens the pdf - but I can’t download it. It downloads a small file which won’t open in preview. Will have another look and let you know if I get it working. Thanks again!
Yes totally, 1 Search records in Airtable module - get rows you need 2 Http download file module 3 Gdrive upload file module 4 Airtable update record - mark that the file has been uploaded.
Hi - thank you for this video! Very helpful. The only issue that I am having is if I override the original file with a new version of the same file (same name), it still uploads the original first version to airtable. Any idea how to get it to update the latest version?
The Airtable is caching uploads, thinking you are uploading the same link/file the way to make sure you always upload latest version and that Airtable always requests latest version is to add to the URL &time=now the "now" can be the time module from Make/Integromat, or "timestamp" or anyother piece of information that will be different vs previous executiong like eg. file version.
any chance you have a solution for when you are going from a google sheet --> download via google drive module --> trying to upload the pdf into Airtable
Thanks so much for making this workaround so soon! In case you are willing and able, I would really appreciate some tips on the following: If Table 1 in your example is a list of organizations. the First column is the organization name and the rest may be city, description, email, and logo. I have all this data (except for logos) on a googlesheet which I currently manually import to airtable. Now I have a google folder with all the logos linked to integromat. Since integromat creates a new row for every file in the google folder, the rest of the datapoints will be empty. I suspect I need to just copy-paste my spreadsheet to airtable to fill those in but Im not sure if there might be a more sophisticated or obvious way to streamline this data together into airtable because now Im juggling a google sheet and google folder for one airtable record and I could imagine this becoming more complex. Hopefully I got my question across clearly. Have a happy new year
OK, I think I got it. One way or another you would have to match the organization logo with the organization (unless filenames are matching with the organization name 1 to 1). If the files are matching or have same order, you could just sort them import images to Airtable and copy paste data from Google - not to over-automate things. If you have to manually match them - you could do it either in Airtable or you could add Google Drive link to the right logo inside of Google Sheet and import everything at once. This would be a combination of above Video scenario with this one: czcams.com/video/t0ODCFZGSlA/video.html (which is Google sheet data import).
The only way to upload file to Airtable via Api is to provide them with a public URL link, from which Airtable downloads the file. It needs to be a public link (without any password or protection). In theory you can get a link like that from Google Drive. Anyone can use a public sharing link to download file... If they use a browser. The problem starts when it is Airtable server making request to Google Server... Google server reject this connection. It used to work in the past, when it stopped i had a long discussion with Airtable support, which also had discussion with Google and this direct file link download from Google to Airtable is a know problem and it sounded like likely they will not fix it anytime soon. I can remember exact details but it has something to do with CDN and preventing people from using Google drive in a similar way to S3 type of service. Long story short - direct public shared link from Google doesn't work, so that's the reason for this workaround.
@@BusinessAutomatedTutorials thanks for ur very prompt response, i was wondering if u could incorporate the webhook response into your first scenario as opposed to using 2 scenarios.
@@leonardlow5342 Not really -> the webhook trigger and response module are bascially what gives a URL returning a file. The first scenario you are informing Airtable what is the URL to use . Afterwards Airtable attempts to downloads the file, which triggers the second scenario. These might be close in time, but these are 2 separate actions.
I followed this step-by-step tutorial you showed in the video, and it worked. Thank you very much for sharing. Now, I want to get the file URL from Airtable and post it on social media. What's the best approach to get the file from Google Drive, upload it to Airtable, and then publish it on Instagram?
Hello, I use simple Make scenario to send audio files from GDrive to Open AI for transcription. I need to run the scenario manually however. Is there a way to start a scenario automatically whenever a new audio file is uploaded to GDrive catalog? Via webhook perhaps? Or there are some Google limitations to such scenario?
Many thanks! Yes, I use that too, but still I need to start Integromat scenario manually, I suppose, so it's active always. I'm looking for solution that sends trigger to Integromat scenario (webhook?) to start whenever new file is uploaded. Or do I need to change schedulling settings?
@@adampilarski514 I would just use Make scheduling but if you really want webhook, that would likely have to use custom api calls to setup webhook developers.google.com/drive/api/guides/push
Hi there! Would it be possible to use a google drive image link on an excel sheet and create another column for posting a link that will suitably work for integromat to upload instagram posts?
Yes it sounds fine. It just needs to be the download link. Also might be that you have to use the Resolve Host module in Make to figure out final location of image server before passing it to Instagram.
Před 2 lety
And if i want to add multiple pictures in a field ?
Hi there, I came here from the other tutorial you linked. I got to the point where the file is supposed to be pulled into the airtable in the attachment field. When I click on the attachment, it just shows a screen for box that says "Accepted' and not prompt a image file download. Does this mean the image URL is broken? (I'm trying to automate the creation of jpg/png URLs for automated instagram posting, from a Google drive folder: File uploaded to Google Drive -> pulled into Airtable as an image url download link -> posted to Instagram.
"Accepted" this is the default response of webhook scenarios when they are not turned ON. Likely when you have run this automation the scenario was not ON, this means instead of returning the file it returned text "Accepted"... It might be also that after the first time, the following times Airtable was caching the response of the webhook, so you might want to add extra parameter to webook "&extraparameter={{now}}" where the {{now}} is the "now" function from Make - means every time above parameter is different so Airtable will ignore caching. Let me know if that helps?!
@@BusinessAutomatedTutorials would I append "&extraparameter={{now}}" in the "FILE URL" field after "webhooklinkurl?id={{id}}"? under Attachment in the airtable Scenario?
Thank you so much bro !!!!!!! You saved me some hours and lot of pain ^^
Glad to hear that
Thank you, amazing! Worked for me :)
Great! Soo good to hear that!
Thank you so much! Great workaround.
Glad it was helpful!
Thanks for doing this video - was hoping it was just what I needed, but I have tried several things - and for some reason, my second Make scenario does not receive the webhook from the Airtable module in the previous scenario. It works when testing (sometimes) - but when used in anger it just sits waiting for the hook to arrive. Maybe something has changed on the Airtable end since this video was produced?
It works, try maybe adding &time={{now}} (or similar with {{now}} being a time variable now() from Make) this will prevent Airtable caching the URL - means if you request same URL multipe times Airtable might hold the cached version from previous request.
Thanks so much! I have (sort of) got it working. It was my user error. Followed your instructions and all (almost) working. Thanks! The issue I have though is that the PDF shows in Airtable and clicking it opens the pdf - but I can’t download it. It downloads a small file which won’t open in preview. Will have another look and let you know if I get it working. Thanks again!
Thank you so much! Can I do the opposite? It's kind of like creating a folder for every records with attached files
Yes totally,
1 Search records in Airtable module - get rows you need
2 Http download file module
3 Gdrive upload file module
4 Airtable update record - mark that the file has been uploaded.
Hi - thank you for this video! Very helpful. The only issue that I am having is if I override the original file with a new version of the same file (same name), it still uploads the original first version to airtable. Any idea how to get it to update the latest version?
The Airtable is caching uploads, thinking you are uploading the same link/file the way to make sure you always upload latest version and that Airtable always requests latest version is to add to the URL
&time=now
the "now" can be the time module from Make/Integromat, or "timestamp" or anyother piece of information that will be different vs previous executiong like eg. file version.
@@BusinessAutomatedTutorials Wow thank you - that is exactly what I needed!
any chance you have a solution for when you are going from a google sheet --> download via google drive module --> trying to upload the pdf into Airtable
I got it to work finally! Issue now will be preserving the desired page breaks on the google sheet --> download via google drive module step!
Cool glad you found the solution! Let me know how it goes!
@@BusinessAutomatedTutorials not so great…I ended up just creating it as a google doc 🤦🏻♀️.
Thanks so much for making this workaround so soon! In case you are willing and able, I would really appreciate some tips on the following:
If Table 1 in your example is a list of organizations. the First column is the organization name and the rest may be city, description, email, and logo. I have all this data (except for logos) on a googlesheet which I currently manually import to airtable. Now I have a google folder with all the logos linked to integromat. Since integromat creates a new row for every file in the google folder, the rest of the datapoints will be empty. I suspect I need to just copy-paste my spreadsheet to airtable to fill those in but Im not sure if there might be a more sophisticated or obvious way to streamline this data together into airtable because now Im juggling a google sheet and google folder for one airtable record and I could imagine this becoming more complex.
Hopefully I got my question across clearly. Have a happy new year
OK, I think I got it. One way or another you would have to match the organization logo with the organization (unless filenames are matching with the organization name 1 to 1). If the files are matching or have same order, you could just sort them import images to Airtable and copy paste data from Google - not to over-automate things.
If you have to manually match them - you could do it either in Airtable or you could add Google Drive link to the right logo inside of Google Sheet and import everything at once. This would be a combination of above Video scenario with this one: czcams.com/video/t0ODCFZGSlA/video.html (which is Google sheet data import).
thanks but i dont understand why can't you combine it into the same scenario but u needed a differnt one ? Sorry i m rather new.
The only way to upload file to Airtable via Api is to provide them with a public URL link, from which Airtable downloads the file. It needs to be a public link (without any password or protection). In theory you can get a link like that from Google Drive. Anyone can use a public sharing link to download file... If they use a browser. The problem starts when it is Airtable server making request to Google Server... Google server reject this connection. It used to work in the past, when it stopped i had a long discussion with Airtable support, which also had discussion with Google and this direct file link download from Google to Airtable is a know problem and it sounded like likely they will not fix it anytime soon. I can remember exact details but it has something to do with CDN and preventing people from using Google drive in a similar way to S3 type of service.
Long story short - direct public shared link from Google doesn't work, so that's the reason for this workaround.
@@BusinessAutomatedTutorials thanks for ur very prompt response, i was wondering if u could incorporate the webhook response into your first scenario as opposed to using 2 scenarios.
@@leonardlow5342 Not really -> the webhook trigger and response module are bascially what gives a URL returning a file.
The first scenario you are informing Airtable what is the URL to use . Afterwards Airtable attempts to downloads the file, which triggers the second scenario.
These might be close in time, but these are 2 separate actions.
How to add a file to an existing table?
find file with Gdrive module, change setting to share with anyone with the link and pass the link to Airtable module.
I followed this step-by-step tutorial you showed in the video, and it worked. Thank you very much for sharing. Now, I want to get the file URL from Airtable and post it on social media. What's the best approach to get the file from Google Drive, upload it to Airtable, and then publish it on Instagram?
@@iomarsantos27 if you have filed on Google drive, it will give you a shared link which you can use to upload to Airtable.
Hello, I use simple Make scenario to send audio files from GDrive to Open AI for transcription. I need to run the scenario manually however. Is there a way to start a scenario automatically whenever a new audio file is uploaded to GDrive catalog? Via webhook perhaps? Or there are some Google limitations to such scenario?
There is a Google drive module called watch files that triggers whenever new file is uploaded. I use that for similar automation.
Many thanks! Yes, I use that too, but still I need to start Integromat scenario manually, I suppose, so it's active always. I'm looking for solution that sends trigger to Integromat scenario (webhook?) to start whenever new file is uploaded. Or do I need to change schedulling settings?
@@adampilarski514 I would just use Make scheduling but if you really want webhook, that would likely have to use custom api calls to setup webhook developers.google.com/drive/api/guides/push
Hi there! Would it be possible to use a google drive image link on an excel sheet and create another column for posting a link that will suitably work for integromat to upload instagram posts?
Yes it sounds fine. It just needs to be the download link. Also might be that you have to use the Resolve Host module in Make to figure out final location of image server before passing it to Instagram.
And if i want to add multiple pictures in a field ?
Yes possible, you could use array aggregator to combine multiple pictures into a single entry.
Hi there, I came here from the other tutorial you linked. I got to the point where the file is supposed to be pulled into the airtable in the attachment field. When I click on the attachment, it just shows a screen for box that says "Accepted' and not prompt a image file download. Does this mean the image URL is broken? (I'm trying to automate the creation of jpg/png URLs for automated instagram posting, from a Google drive folder: File uploaded to Google Drive -> pulled into Airtable as an image url download link -> posted to Instagram.
"Accepted" this is the default response of webhook scenarios when they are not turned ON. Likely when you have run this automation the scenario was not ON, this means instead of returning the file it returned text "Accepted"...
It might be also that after the first time, the following times Airtable was caching the response of the webhook, so you might want to add extra parameter to webook "&extraparameter={{now}}" where the {{now}} is the "now" function from Make - means every time above parameter is different so Airtable will ignore caching.
Let me know if that helps?!
@@BusinessAutomatedTutorials would I append "&extraparameter={{now}}" in the "FILE URL" field after "webhooklinkurl?id={{id}}"? under Attachment in the airtable Scenario?
@@BusinessAutomatedTutorials I got it to work, thank you!
@@huyenbhoang webhooklinkurl?id={{id}}&extraparameter={{now}