Table of Contents
Do not index
Do not index
In today’s lesson you’re going to create a simple automation between Google Sheets and Baserow.
Remember the data you collected yesterday in Google Sheets? Today you’re going to automatically send that data to a new table in Baserow.
Let’s dive in. 🌊
Task for the Day 📝
🧱 Project: Create a Google Sheets to Baserow Automation
⏲️ Estimated time: 30 minutes
Context Building 🏔
In today’s lesson you’ll continue the theme of learning some basic automations. Continuing on from yesterday’s lesson, you’ll automatically populate a table of data in Baserow (hello again 👋) once the data has been added to Google Sheets.
Yesterday you created a public form that collected data and automatically sent it into a Google Sheet. Today, you’ll send that same information from your Google Sheet to Baserow. Your full workflow now looks like this:
- Questmate to Google Sheets
- Google Sheets via Zapier to Baserow
Automations, like the one you’re going to create today, are all about making life more seamless and efficient. While Google Sheets might be a sufficient place to collect data, it’s not always the best platform to store, process, filter or view information in useful ways. That’s where Baserow offers a more robust solution.
To get the information from Google Sheets into Baserow without an automation, you’d have to copy and paste all the information from Google Sheets into Baserow manually, and that might take a lot of time. Also, in this use case, you’d have to keep checking Google Sheets to see when it had been updated so that you’d know when to copy information across.
Using a Zapier automation (known as a Zap), information is transferred from Google Sheets to Baserow as it happens. ⚡
In this lesson you’ll learn:
- How to create an automation between Google Sheets and Baserow
- How to create a ‘Zap’ in Zapier
Let's Prep 🥗
Today’s lesson continues on from yesterday’s lesson, where you built a Quest in Questmate and then the data was collected and populated in a Google Sheet.
You’ll use that same Google Sheet that you created for today’s lesson.
If you followed along with yesterday’s lesson explicitly, today’s lesson will continue with that same use case. But don’t worry if you created something different, you should be able to use the step-by-step guide and adapt it easily for your use case.
In today’s lesson you’ll also be introduced to Zapier, the world’s most popular workflow automation platform. You can think of Zapier as a translator that allows thousands of different platforms to talk to each other. As a user, you can then integrate lots of different software to improve your workflow, without having to know how to program. Automations in Zapier are known as ‘Zaps’ and are comprised of triggers (if this happens) and actions (then this should happen).
🔥 Get ready to build!
To make your life easier when you build, it’s good to get some practical stuff out the way first. Follow these steps so you’re ready to build:
- Open up the spreadsheet you used to collect data from Questmate in yesterday’s lesson (if you were following the example it is called ‘no code resources’
- Open up Baserow in a separate tab and log into your dashboard
- Open up Zapier in a separate tab and sign up for an account
It’ll be handy to have these platforms open in separate browser tabs as you’ll be switching between them in today’s lesson.
Time to Cook 👩🍳
Follow the steps below to build:
- Open your Google Sheet from yesterday, Baserow and Zapier in new browser tabs.
- Follow this step-by-step guide to complete today’s lesson.
That’s a wrap, we hope you found this lesson helpful!
- If you have any questions, feel free to reach out.
- Want to learn NoCode? Join #100DaysOfNoCode for free.
- Want to learn AI skills? Join #100DaysOfAI for free.
Written by
