get data into glide apps using zapier

4 MIN READHow To Get External Data Into Your Glide Apps Using Zapier

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.

» BROWSE NOW: Use One of These Templates To Kickstart Your Journey with Glide Apps

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

glide apps image cta for professional templates

MORE READING