Glide is the perfect tool for bringing Google Sheet data to life in vivid and highly useful apps but, for many of these, information is hard to update without an external tool like Zapier.
Unless you plan to spend potentially hours per day doing that manually, Zapier allows you to automate the process of keeping your Glide apps updated.
Zapier connects with 3,000+ apps – Google Sheets amongst them – giving you a wealth of options when it comes to importing data. Let’s explore a few ideas:
Getting data from RSS feeds
Many blogs and other publishing services still use RSS feeds – so if you’re building a Glide app that displays blog posts from other sites – the most sensible option is to build a zap that triggers on new RSS items and creates a new row in Google Sheets.
Got many RSS feeds you want to pull in? Consider adding them all to Feedly and having new Feedly items go to the Google Sheet – then you can have all your feeds managed through one zaps.
Parsing from emails and into Glide
Not every app has a Zapier integration, forcing you to get creative if you want the data in a Google Sheet. For example, many people manage Airbnb apartments and one great use case would be to see property bookings in a Glide app.
Airbnb doesn’t have a Zapier integration, but you do get emails from them with booking details. The solution here is email parsing, which means that using a tool like Parseur, you can create new Google Sheet rows with data extracted from every email received.
Not a property owner? Well this idea is applicable to any situation where you get email notifications.
From webhooks to Glide via Zapier
Zapier integrates with 3,000+ apps at this point, so if you want to get data from any of them into Glide, it’s as simple as setting up a zap with a trigger that writes a new row in your Google Sheet.
But, what if the app you use doesn’t have a native Zapier integration?
Well, don’t give up yet… Many apps support webhooks.
Webhooks are a shared language that allow apps to communicate data between each other.
Many newer apps let you create webhooks, so that when something happens in that app – for example a new contact record is created – the data can be sent over. In this case you can build a zap with a webhook trigger to receive that data, then write it to a Google Sheet.
Bulk export data via CSV and display in Glide
One thing Zapier isn’t good at is syncing historical data – but with most services allowing you to export CSV files, there is a workaround.
Saw you want to export all current leads from your CRM into a Glide app. Sure you can export a CSV and copy the rows into the Google Sheet, but if you want things a little more automated, then there’s a way.
Create a zap that triggers on a new file in a Google Drive, uses a Formatter step to parse the rows from the CSV and writes them to your Google Sheet. Easy!
Originally published Feb 26 2021
Jesus is the founder of Low Code Agency: a low-code development agency that allows small business owners to get their mobile and web apps done fast and cost-effectively while maintaining quality.