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.
- Protecting sheets against unwanted changes
- Rearranging rows and columns
- Adding data validation to cells
- Using the image function to easily add images to cells
- Inserting a gauge chart for status updates
- Adding estimate data to Google charts
- Publishing charts to a website
- Using Google Forms to create surveys
- Using Google Sheets add-ons