Hmm that'd require you to be able to create a file via scripting, which I'm sure is possible but off the top of my head I can't think of how I'd do it. After that you'd need to upload it somewhere else as Airtable attachment fields require a URL to upload files, we can't upload files directly
With reference to the guide you linked, I'd try:
1. Use the send email step to create the .ics file
2. Have another automation that triggers when it receives an email (like the mailhook)
3. Upload the file into Google Drive, get a shareable link, and then upload it in to Airtable
I'm sure there's a more streamlined way to do it but the above should work
Hmm that'd require you to be able to create a file via scripting, which I'm sure is possible but off the top of my head I can't think of how I'd do it. After that you'd need to upload it somewhere else as Airtable attachment fields require a URL to upload files, we can't upload files directly
With reference to the guide you linked, I'd try:
1. Use the send email step to create the .ics file
2. Have another automation that triggers when it receives an email (like the mailhook)
3. Upload the file into Google Drive, get a shareable link, and then upload it in to Airtable
I'm sure there's a more streamlined way to do it but the above should work
Thanks for the advice, I didn't realize attachment fields need a URL for upload.
Cutting out the email middle man, I can use Make to directly save the file to GDrive, and then conceivably Make tells GDrive to attach the file using GDrive's URL, but I'm running into two more problems. One is GDrive wants to save the file as XYZ.ics.txt, appending the .txt on the end of my specified format.
The other problem is that even though Make says everything is successful, file attachments aren't populating in my base. Make is affecting the record (I enabled a change in a select field to show that changes are being pushed) but nothing shows up in the attachement field, even though Make says it does... I wonder if it's a handoff problem between GDrive and AT?
Thanks for the advice, I didn't realize attachment fields need a URL for upload.
Cutting out the email middle man, I can use Make to directly save the file to GDrive, and then conceivably Make tells GDrive to attach the file using GDrive's URL, but I'm running into two more problems. One is GDrive wants to save the file as XYZ.ics.txt, appending the .txt on the end of my specified format.
The other problem is that even though Make says everything is successful, file attachments aren't populating in my base. Make is affecting the record (I enabled a change in a select field to show that changes are being pushed) but nothing shows up in the attachement field, even though Make says it does... I wonder if it's a handoff problem between GDrive and AT?
Problems solved!
I can append .ics at the importation to Airtable renaming the XYZ.txt file XYZ.txt.ics and it functions as a calendar file. Meanwhile my attachment issue was that the Gdrive folder I was using to hold the files wasn't set to share publicly. I still have some tweaking to do on the text side (my timezones are wrong) but everything now works in principal.
Should anyone want a similar build, I've attached a screenshot of my make diagram
Problems solved!
I can append .ics at the importation to Airtable renaming the XYZ.txt file XYZ.txt.ics and it functions as a calendar file. Meanwhile my attachment issue was that the Gdrive folder I was using to hold the files wasn't set to share publicly. I still have some tweaking to do on the text side (my timezones are wrong) but everything now works in principal.
Should anyone want a similar build, I've attached a screenshot of my make diagram
Oh woah, that's super cool, I never knew you could just create a file like that
Thanks for sharing!
