* EARLY-BIRD PRICING ENDING SOON! * Turn your business idea into reality in 5 weeks with this best-selling cohort-based course –>
No items found.

Get data from an API with Parabola + Google Sheets

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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.

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.

Become a Pro member to access all content

240+ instructional videos led by professionals
Weekly expert workshops and replays
1-1 consultation with the Makerpad team
Over $50k in discounts for tools
Private peer community
Profile for tracking progress and sharing your work
Yearly pricing
$249/year
Start your 7 day free trial*
Get PRO Yearly
Lifetime pricing
$600billed once
Start your 7 day free trial*
Get PRO Lifetime

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.

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.

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.

Get help and discuss

Open community forum
Close

Sign up for our weekly updates

Get an update every Sunday with new content, news and a behind-the-scenes of what our community are building.
Join over 18,000 others
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.

Related Tutorials

view all ⭢