Spreadsheets are perhaps the perfect place to store your data. They’re flexible, and simple enough for anyone to use—especially if you’ve turned them into an app with AppSheet.
But what if you want power up your spreadsheet-centric app with features like push notifications? Or what if you want to automatically update your app from other apps?
App integration tool Zapier can add those features and more to your app. Here’s how—read on for the steps you need to get push notifications from your app, and to add your new blog posts to your app automatically.
AppSheet apps are a great way to collaborate on data, since your team can both view and edit your spreadsheet right from the app. The only problem is, keeping track of all the changes can be difficult.
It doesn’t have to be, though. Just connect your app’s spreadsheet to Zapier, then have Zapier send you a notification whenever a change is made. Zapier could send you an email, SMS, or push notification with tools like PushBullet—or it could post the notification to a team chat app like Slack.
For this tutorial, let’s use Zapier’s SMS tool to get notificated whenever your spreadsheet is updated.
To start out, just create a Zapier account, and click the Make a Zap icon in the top right corner to start building the integration. Select Google Sheets as your app, then select the Updated Spreadsheet Row trigger—that’s the tool that’ll watch your spreadsheet for changes.
In the next step, connect Zapier to your Google Sheets account, then select your app’s spreadsheet and worksheet from the drop-down menus. You can also select a specific column to watch for changes, if you only want notified when that one column is updated. Or, leave the default any_column option to watch your entire sheet for changes.
Click Continue, and Zapier will find the column that’s been most recently changed to use in your notification.
Now, it’s time to choose how you’ll get notified when the spreadsheet is updated. You can choose any app you want, but we’ll choose the SMS by Zapier app to get an SMS message whenever a row is changed.
Select Send SMS, then add your phone number and authenticate it in the next step.
All that’s left is to add info to your SMS message. In the Message field, type out whatever you’d like your message to say, then click the + icon on the right to add text from your spreadsheet. You could add the column with the name of the item that was updated, perhaps, along with the other columns you’d want to check for changes.
Test then turn on your Zap, and then whenever someone makes a change to your spreadsheet from AppSheet, you’ll get a customized SMS message with the info.
Then, you can also use Zapier integrations to add data to your apps automatically. Say you want an app that shows your latest blog posts—a spreadsheet, a Zapier RSS integration, and AppSheet are all you need.
First, setup your spreadsheet with columns for your post title, body, publish date, and perhaps a header image that’ll look nice in your AppSheet app. Setup your app in AppSheet, perhaps pasting a couple recent posts into your spreadsheet first to test it out.
You could keep pasting in new posts ever time—or a Zap could do it for you. Just open Zapier and click Make a Zap again, and this time choose the RSS by Zapier app. In its setup screen, enter your blog’s RSS feed along with any other info you need (your feed itself should be enough, though).
Now, add another step to your Zap, this time selecting Google Sheets as your app. Choose the Create Spreadsheet Row action, since we’re having Zapier add your blog post to the spreadsheet.
Then, select your Google Sheets account and the spreadsheet you’re using for this app. You can then see each of the columns you’d added to your spreadsheet. Click the + icon to the right of each one, and select the correct item from your RSS feed for that column—matching the post title to your title column, and so on.
Test and turn on the Zap, and the next time you publish a new blog post, it’ll show up in your AppSheet app automatically.
Want to find more more ways to connect your AppSheet app to other apps, add data to your app automatically, and get notified whenever anything’s changed? Or want to learn more about Google Sheets’ advanced formatting features that can help you make your spreadsheet and AppSheet app look just like you want?
Then check out Zapier’s new free ebook, The Ultimate Guide to Google Sheets. It teaches you everything you need to know about Google Sheets spreadsheets, from the beginner steps to sort and format your data to advanced tips that let you import data from websites, automatically format your spreadsheets with Google Apps Scripts, and much more.
Download a copy—and set up your own integrations to make your AppSheet apps more powerful.