Transferring images from Airtable to Glide Tables

Ask for Help
1

Hi, I’ve finally made the jump from Airtable to Glide Tables. I had a table with 1,000+ rows with 50+ columns, including several attachment columns. To save time, instead of creating a Glide Table from scratch and then uploading the rows one by one, I instead synced my Airtable table and then ‘duplicated’ the table in Glide’s data tab. This created a new native Glide Table with all the data intact. I now only have to recreate all the connections (which is a big time-killer but I’m ready to do it).

However, I found out from support that the attachments that I have in this new table will be lost 30 days after I disconnect my Airtable base, because these attachments are mirrored from Airtable. Makes sense. Now it seems I have to upload the 5,000+ attachments from one column to another for each row one by one. In my attachment field, I have multiple files, and some of them have videos, PDFs, images and ZIP files.

Is there any automation or cloud service that can do this for me?

2

I guess there isn’t an easy way, and since Glide also doesn’t showcase an endpoint where you can upload files, this makes things harder.

I haven’t tried to see if multiple files columns are exposed to the API, my thinking assuming they are, is:

  • Use Make to query your full table.
  • Iterate through each row of your table, get the multiple files column that was mirrored from Airtable.
  • Iterate through the list of files, upload them to somewhere, get the links back, then send the array of new links back to a new multiple files column in the same Glide Table.

Even if that works, it will cost you a lot of operations and data transfer in Make.

1 Like
3

Thanks, I’ll try this. I’ll use Pabbly Connect (a Zapier/Make alternative) where I already have a 20k tasks monthly subscription that I’ll finally put to good use :stuck_out_tongue:

1 Like