I’m wondering if anyone has found a good way to do this. I’d like to import data from a spreadsheet. Then have a way to transform that data and populate existing tables within a base.
In my existing spreadsheet I would have columns that go to different tables within one base.
+4Hi
It may be able to be done with Zapier (as always the devil’s in the details). I have done similar things for a client before.
Julian
Hi
It may be able to be done with Zapier (as always the devil’s in the details). I have done similar things for a client before.
Julian
The problem I seem to have in Zapier is getting it to do this with existing data. I can create a Zap that will take the data from a table into another table when new records are created. However this doesn’t solve the issue.
+4The problem I seem to have in Zapier is getting it to do this with existing data. I can create a Zap that will take the data from a table into another table when new records are created. However this doesn’t solve the issue.
Are you saying that pasting data into Airtable is NOT causing your Zap to see a new record?
Have you tried using new record in a view - based upon a filter? You could then update the filter field from the Zap.
Are you saying that pasting data into Airtable is NOT causing your Zap to see a new record?
Have you tried using new record in a view - based upon a filter? You could then update the filter field from the Zap.
Correct. I have setup the Zap with a record in one table called RawData. It’s setup to populate a table named Leads when RawData gets new records. I tested and it worked. Then I pasted ~ 1K worth of records into RawData. Leads is not populating. Based on what I know this should work.
I think I have it working now. I loaded the table off a view. I added an import flag to RawData and created a view filtering from it.
I ran the zap and it worked!
Thanks for the help!
+4I think I have it working now. I loaded the table off a view. I added an import flag to RawData and created a view filtering from it.
I ran the zap and it worked!
Thanks for the help!
Hi Damon
That’s great - the Zapier / Airtable combination works pretty well. Just needs instant Zaps triggered by a field/record update to complete the set!
Julian
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.