ExploreEducationHow do I build?MembersToolsWorkshopsJobs
Memberships & bootcamp enrolment closes April 10th. Sign up now to claim your spot.

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.

My Profile:

Edit your bio
My profileMy progressSubmit a project

Share

Bring no-code to work

Save time, avoid the backlog and ship faster. Implement automated workflows to eliminate repetitive tasks in minutes.
For BusinessesFor individuals
Tutorials
/
🔢 Get data from an API with Parabola + Google Sheets
Added to your list!
Oops! Something went wrong while submitting the form.
Marked as complete!
Oops! Something went wrong while submitting the form.
Mark as completeSave to watch later

🔢 Get data from an API with Parabola + Google Sheets

Link to Demo

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.

You must be a member to view the full lesson

Memberships & bootcamp enrolment closes April 10th. Sign up now to claim your spot.

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