Name: Retrieve And Tweet Information from Google Spreadsheets
Uploaded: 2017-03-07T17:45:52-06:00
Description: In this lesson, we’ll learn how to retrieve and tweet data from Google Spreadsheets. We'll use Tabletop.js to make this easier. More information on Tabletop can be found at https://github.com/jsoma/tabletop.

Set Up a Basic Twitter Bot with Twit.js

Post Statuses with Twit.js

Work with Users in Twit.js

Interact with Tweets with Twit.js 

Use the Twitter Search API with Twit.js

Use the Twitter Stream API with Twit.js

Tweet Media Files with Twit.js

Make A Bot That Sounds Like You with RiTa.js

Make a Bot That Analyzes Human Emotions in Photos with Google Cloud Vision API

Make A Story Generation Bot with Tracery

Retrieve And Tweet Information from Google Spreadsheets

Make a Twitter Audio Bot That Composes a Song Based on a Tweet

Host a Simple Twitter Bot Using Heroku

Host a Complex Bot using Heroku and Docker

Create your own twitter bots

In this lesson, we’ll learn how to retrieve and tweet data from Google Spreadsheets. We'll use Tabletop.js to make this easier. More information on Tabletop can be found at https://github.com/jsoma/tabletop.

https://app.egghead.io/api/v1/lessons/node-js-retrieve-and-tweet-information-from-google-spreadsheets/subtitles

[00:00] In addition to Twit, we'll need Tabletop, which is require ('tabletop'). In the Google spreadsheet we want to use, we need to make sure we have a header, which in this case is the URL of an interesting API resource.

[00:13] We need to say file publish to the Web. We press "publish," and then copy this link. Here, we'll say parse spreadsheet URL= this link. Then we say table top.init. This takes three things. A key, which is our spreadsheet URL, our callback function, which is data, tabletop, and whether or not it's a simple sheet, which is true if we only have one sheet.

[00:49] Let's see what that gives us. We can see a couple of APIs from this course. We can see ProgrammableWeb, which is an excellent resource to find other APIs, as well as ProPublica, which hosts an API of Congressional actions, including bills, votes, roll calls, etc.

[01:05] To tweet these, we can say data.for each.post statuses/update with a status, which we'll make up here. It's d.url is a great API to use for Twitter bots. There's an error, we'll log it out. Otherwise, we'll say post in. We can see that it worked.

Retrieve And Tweet Information from Google Spreadsheets

Share this video with your friends

Course

Create your own twitter bots