Help

Re: Parse CSV Attachment With Integromat

6785 0
cancel
Showing results for 
Search instead for 
Did you mean: 
Damon_Talbot
7 - App Architect
7 - App Architect

So I have been working on various integrations using Integromat for my Destiny Search Project system. I have come to a roadblock and looking for some help…

I have an Attachment field in Airtable that has a .csv file in it. The file is formatted with the same fields as a table in the Airtable database. I want to be able to export the data from the csv then import it back to the other table. The issue I am having is figuring out how to use the Parse CSV tool in Integromat to run through the file from Airtable.

5 Replies 5
M_k
11 - Venus
11 - Venus

Hi @Damon_Talbot

I have a similar scenario, with a few different modules. I will include screenshots of the scenario and see if you might be able to use any of the information.

I hope you can find something useful.

Mary K

4B94081A-11B5-4934-82F8-258127C2023D.png D365B5B2-C473-4DE8-9879-AB91DBF5CAEE.png 406915D1-2322-4863-BF29-9883E91EAEB7.png 466B2C9E-F320-472E-949E-51B96A7122D1.jpg 8E5C4D01-67BF-4FDC-811C-E039F6A0182C.png

Or you could try this, using Google Drive. You would need to export the CSV file from Airtable in CSV format, then save it to Google Drive. Then you would run it through the scenario, similar to the one below. If you need any help with this part, let me know. I might be able to help you. Just disregard the Variable section near the bottom of the Tools module and the CSV section near the bottom of the CSV module (it’s a custom setup for my use case). If you need help with the setup for the Airtable modules, let me know. I will try to help out.

33A07ACB-491D-46B1-8CBA-546863138D72.png 90C05921-D2C8-4B87-8B5A-5448BD5E3A35.png A2466C04-273F-475D-8BF2-7C6E2FE1331A.png 6E2BBCCB-42B1-4F33-B285-8A508729AF53.png C91E38E7-8BE5-4587-894A-5C5FB8B0B652.png 020D762A-10B2-4361-AEA9-9E692156D1F8.jpg 221233B6-7A68-497E-A264-7CCB59462185.png 51FE8883-659F-4AAD-8DDB-1CCDE065E690.png

Thanks, the big thing I was missing was using the HTTP Module to actually perform the GET of the file. I was trying to reference it directly from the Airtable module. Now that I know how to get the files I changed my methodology a bit and using the JSON module instead which is working great.

Just some background and how we will be using the integration. We have been using a embedded form that our mapping team would have to fill out for each new map assignment being created for our search operations. Using the Integromat tool I am now able to have the mapping volunteer simply upload the GeoJSON file from our map tool and then it creates all the map assignments in Airtable at one time. Over the course of a major search with dozens or even over a hundred maps this could save a few hours overall in our process.

Hi @Damon_Talbot

That’s great!

I’m glad it worked out.

Mary

Gary_Stark
5 - Automation Enthusiast
5 - Automation Enthusiast

@Damon_Talbot this was ENORMOUSLY helpful…THANK YOU!!

Thanks for the example

I am trying to use Parse CSV but the process does not finish. The Parse CSV action is paused and does not add a row.

Can you help me?

image