Sign up for updates

Get a weekly update every Sunday with our announcements, company updates and a behind-the-scenes of what our community are building.
Over 11,000 people get our updates, join us!
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.
⭠ all tutorials

Get data from an API with Parabola + Google Sheets

This tutorial is available for pro members only

Request access

In this tutorial we'll show you how you can get data from an API, manipulate it into the shape you want and output it into a Google Sheet using Parabola.

What you will need

Login and create a new Flow in Parabola. Next add an API Import component and paste in your API endpoint into the API Endpoint URL field.

For authentication, select Bearer and paste your API access from where ever you are getting your endpoint from.

Now Get Results. You should now see some data in the main screen.

Next, exit the API Input screen and add a JSON flattener component to flatten the nested JSON data.

Use the Column Filter component to remove the columns containing the now useless columns that contain the unflattened JSON.

Finally add a Google Sheets component to the end, connect it to your Sheet.

Publish your flow and press Run.

If you have done the above steps right you should have some clean API data in your Google Sheet ready to use for your project.

Hope you found this tutorial useful and if you have any questions send me a message inside of the Makerpad Slack or on twitter @tomosman.

Thanks.

The full tutorial is available for pro members only

Request access

In this tutorial we'll show you how you can get data from an API, manipulate it into the shape you want and output it into a Google Sheet using Parabola.

What you will need

Login and create a new Flow in Parabola. Next add an API Import component and paste in your API endpoint into the API Endpoint URL field.

For authentication, select Bearer and paste your API access from where ever you are getting your endpoint from.

Now Get Results. You should now see some data in the main screen.

Next, exit the API Input screen and add a JSON flattener component to flatten the nested JSON data.

Use the Column Filter component to remove the columns containing the now useless columns that contain the unflattened JSON.

Finally add a Google Sheets component to the end, connect it to your Sheet.

Publish your flow and press Run.

If you have done the above steps right you should have some clean API data in your Google Sheet ready to use for your project.

Hope you found this tutorial useful and if you have any questions send me a message inside of the Makerpad Slack or on twitter @tomosman.

Thanks.

Lesson details

In this tutorial we'll show you how you can get data from an API, manipulate it into the shape you want and output it into a Google Sheet using Parabola.

What you will need

Login and create a new Flow in Parabola. Next add an API Import component and paste in your API endpoint into the API Endpoint URL field.

For authentication, select Bearer and paste your API access from where ever you are getting your endpoint from.

Now Get Results. You should now see some data in the main screen.

Next, exit the API Input screen and add a JSON flattener component to flatten the nested JSON data.

Use the Column Filter component to remove the columns containing the now useless columns that contain the unflattened JSON.

Finally add a Google Sheets component to the end, connect it to your Sheet.

Publish your flow and press Run.

If you have done the above steps right you should have some clean API data in your Google Sheet ready to use for your project.

Hope you found this tutorial useful and if you have any questions send me a message inside of the Makerpad Slack or on twitter @tomosman.

Thanks.

Previous submissions
No items found.
Supporting details

You must be a member to view the full lesson

Get started with
Makerpad today

The #1 platform for no-code education. Join over 10k others and discover what's possible.

Business

Multiple seat access, hire talent and custom training.

Learn more
Individuals

Unlimited all-access to our online bootcamps and community.

Get started
Email updates
You're in 😍- check your email to get started. Tweet me what you want to build to see how to do it without code.
Oops! Something went wrong while submitting the form.

If you'd like this template, message @bentossell on Slack with your email for the account to send this template.

Ready to get started?

Join the community and start turning your ideas into solutions