IFTTT stands for If This Then That, and is a free web service to automate other web services you may use. Jess Stratton shows how to use IFTTT to automatically append rows to a Google Sheet.
- [Instructor] The popular web service IFTTT stands for…if this, then, that.…You can connect up to all of your favorite web services…and create conditional rules to automate tasks…which they call Recipes.…For example, you can turn on your Hue lights…automatically if it's raining out.…You can have photos you're tagged in on Facebook…get sent to a cloud storage service like Google Drive.…You could also have data automatically appended…to a Google Sheet, which is what we're going to do today.…I point in my browser to IFTTT, that's ifttt.com,…and I create an account and I'm all logged in.…
This is where you're going to be taken…when you've logged in.…IFTTT is completely free and all you need is…an email address and a password to signup.…After that, it's a matter of connecting IFTTT…to the accounts you use every day.…I'm going to create a Recipe to automatically append…mentions of Landon Hotel's Twitter account…to a Google Sheet.…This will require two connections for IFTTT,…Twitter, which I've already connected my Twitter account…
Lynda.com is a PMI Registered Education Provider. This course qualifies for professional development units (PDUs). To view the activity and PDU details for this course, click here.
The PMI Registered Education Provider logo is a registered mark of the Project Management Institute, Inc.
- Explain why it is beneficial to use a template spreadsheet in Google Sheets rather than start from scratch.
- Name the action you would need to take to make data fit in a column on a Google sheet.
- List the steps to include multiple lines in a cell.
- Explain how to use the iframe code for a chart when publishing it to a website.
- Recall the main advantage of using IFTTT services with Google Sheets.
- Recognize situations where Google Sheets email notifications would be useful.