![]() ![]() ![]() Zapier has a feature where they “pause” a zap if it’s running too many tasks at once – sort of like how a credit card company will call you if they see you made an out-of-the-ordinary purchase. UPDATE Hmm, I just ran into a problem! Zapier batched about 2 dozen entries in one import, but now it’s doing one at a time? Something squirrelly going on! I’ll update once I know more. Again, I realize how totally ridiculous and work-aroundy this whole thing is! But I spend a lot of time with Zapier and Airtable, so the whole thing went pretty smoothly for me. Give it a try and let me know if you run into any problems. In 15 minutes, Zapier will check your Airtable, see all the new entries, and run the zap. That will “move” all the entries into the new “Imported to Webflow” view. You can just check one, highlight it, and then grab the little square in the bottom right and drag down to “paste” the content into every field. You do also need a few h…Īfter that, just test your zap and make sure Zapier is able to write to Webflow, turn on your zap, and you’re done! The final step is to go back to Airtable and “check” the boxes in the column “Import!”. ![]() And by “hand-write”, I mean choose “Custom Request” from the bottom of the Zapier menu. In looking at your screen shot, you may have to hand-write the JSON payload – that’s how I did it, and it works, so I’m actually not sure about the other technique. It’ll take a little time, so for now let me try to help via text. Hey video tutorial is a fine idea! I’m also using this same approach to do a batch CSV import into Webflow, so I can include that as well. Remember that a) the entire JSON data payload has to be enclosed in curly braces, and b) images are not yet supported by the API! The nice is thing is that Zapier provides all the variables for you from the previous (Airtable) step, so that you can just click and choose from a dropdown. I just pulled this from the developer docs as a sample obviously you’ll want it to map to whatever fields you have in your collection. "post-summary": "Summary of exciting blog post", On the “Edit Template” page, choose POST for the method (assuming that you’re creating new entries), the endpoint URL for the collection you want to import to (looks like /items), leave “Data Pass-through” as ‘no’, and for the data, you want it to look like:.Click the link “show less common options” and select “Custom Request” For the action, select “Webhooks by Zapier”.Under “Edit Options”, select the (data)Base, Table, and View (“Imported to Webflow”) in question.Create a new zap with Airtable’s “New Record in View” as the trigger.This is the trigger for the Zap you’re about to make) For the new view created in step 3, set a filter that only includes entries that are “checked” with the field from step 2 (What this does is make it so that, when you check an entry in your main view, it “shows up” in the secondary view.Create a new grid view in your table called “Imported to Webflow” (or whatever you want).Create a new checkbox column in your spreadsheet called “Import!” (or whatever you want).Format the data however you want, clean up any artifacts from the original dump Import the CSV to Airtable (again, Google Spreadsheet will wok, but Airtable is free and better, so why not try it?).OK, this is sort of ridiculous, so bear with me here: Go back to Airtable and “check” all the boxes for importĮt voilà, after 15 minutes, you will have batch imported every record! Actual Steps.Use Zapier’s custom webhook to POST the data to your collection’s API endpoint.Then, create a zap that is triggered by any new records that show up in a specific Airtable view (the one you just created).You create a separate “view” in Airtable that contains only the set of records in the main view that meet a specific criterion: in our case, that have been checked for “import”.You import the CSV into a spreadsheet (Airtable preferably, though you could probably get it to work with Google Spreadsheets as well).The collection ID of the Webflow CMS in question. ![]() An Airtable account (Google Spreadsheet will work too, I just prefer Airtable).Your database of entries (say, a Wordpress SQL dump) as a CSV file.I got 153 entries imported start to finish from an old site in about 15 minutes. I know the team is working hard on an import tool for the CMS, but if you’re impatient like me, there are ways to import all your content now using Zapier! It’s fairly laborious the first time you do it but if you’re familiar with Zapier (and the Webflow API), it shouldn’t take you too long. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |