Is there a way to retrieve data with JSON from Airtable and display it directly in Webflow, since Node.js is not supported?

Published on
September 22, 2023

Yes, it is possible to retrieve data with JSON from Airtable and display it directly in Webflow, even though Node.js is not supported. Here's how you can do it:

  1. Connect Airtable to Zapier: Zapier is a tool that allows you to connect different apps and automate workflows. Start by creating an account on Zapier and connecting Airtable as a data source.

  2. Create a Zap: In Zapier, a "Zap" is a workflow automation. Create a new Zap and set Airtable as the trigger app. Select the Airtable base and table from which you want to retrieve data.

  3. Configure the Trigger: Specify the conditions that trigger the Zap. For example, you can choose to retrieve data whenever a new record is added or when an existing record is updated.

  4. Retrieve data from Airtable: In the next step, configure the action app in Zapier. Select the "Code by Zapier" app as the action app. This app allows you to write custom code to manipulate data.

  5. Process data using Javascript code: Write Javascript code in the Zapier editor to handle the retrieved data. You can use the built-in "Code" action to process the data and convert it into the desired format, such as JSON.

  6. Output data as JSON: In the code, format the retrieved data into JSON format. Zapier provides a JSON.stringify() method to convert Javascript objects into JSON.

  7. Send data to Webflow: Finally, set up the "Webflow" app as the destination app in Zapier. You can use the Webflow CMS API to create or update collections in your Webflow project using the JSON data.

By following these steps, you can retrieve data from Airtable, process it using Zapier's Code by Zapier app, and then send the formatted JSON data to Webflow using the Webflow API. This allows you to display the retrieved data directly on your Webflow site.

Additional Questions:

  • How can I integrate Airtable with Webflow?
  • What are some alternatives to Node.js for retrieving data from external sources in Webflow?
  • Can I update Airtable data from my Webflow site using Zapier?