Google Script application Connecting to Twitter API and more
4.6 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
756 students enrolled

Google Script application Connecting to Twitter API and more

Connect to the Twitter API collecting Tweet object information neatly as rows in Google Sheets using Google App Script
4.6 (30 ratings)
Course Ratings are calculated from individual students’ ratings and a variety of other signals, like age of rating and reliability, to ensure that they reflect course quality fairly and accurately.
756 students enrolled
Created by Laurence Svekis
Last updated 11/2019
English [Auto]
Current price: $129.99 Original price: $199.99 Discount: 35% off
7 hours left at this price!
30-Day Money-Back Guarantee
This course includes
  • 2.5 hours on-demand video
  • 14 articles
  • 3 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
  • Certificate of Completion
Training 5 or more people?

Get your team access to 4,000+ top Udemy courses anytime, anywhere.

Try Udemy for Business
What you'll learn
  • How to use Google Sheets to retrieve tweet object data
  • How to create applications within Google Sheets
  • Programming with App Script
Course content
Expand all 39 lectures 02:39:59
+ Introduction to Google Apps Script
13 lectures 01:02:42
Logger Log Write your first function
Add to Google Sheet UI option
Class UrlFetchApp Fetch Method read response data
Source Code
Parse JSON data output object information
Output to Google Sheet
Exercise try URL fetch method
Exercise Source Code
Get URL source code of any website exercise
Source Code for URL scrapper
Google Script Resources and more information
+ Google Sheets HTTP Requests
8 lectures 25:08
Power UP Google Script create a document send an email
Source Code Create doc email out link
Create Google Document
Source Code Create Document
GmailApp class send email method
Source Code GmailApp
Send Post request to URL google Script
Section resources and Source code
+ Twitter Listener Twitter Scrapper using Google Script
17 lectures 01:10:55
Intro to Twitter Developer
Twitter Keys and Developer Access setup
Twitter authentication setup Issuing application-only requests
Source Code And links
Store Token into Properties
Source Code Resources
Search Twitter API return data
Twitter Search Script
Get live tweet objects
Tweet Object data into Google Sheet
Twitter Data into Google Sheet columns
Search Dialog quick search Twitter output results to Google Spreadsheet
Source Code Search Twitter
Setup Automated Search to Twitter API
Google Sheet Get last Row values and more
Twitter API connection conclusion
Resources and Source Code
  • JavaScript
  • Twitter developer experience

Do you want to be able to connect to the Twitter API, search a term and have the results pulled directly into your Google Spreadsheet?  Or even automate a listening system to pull regular data from Twitter into a spreadsheet?  Search any term on Twitter and return the results......

Learn how to build an application within Google Sheets to search tweets from Twitter and pull them directly into your spreadsheet.

Google Script Twitter Listener!!!  This is an in demand application that you can build using Google Script to listen and pull Tweet Objects on a regular trigger.  Its easier than you think to make you own social media listening app which builds a spreadsheet full of tweet data automatically.  This is something that I setup for a client and now I'm sharing the source code and how to set it up with you within this course.  Yes source code is 

In this course we show you how to build this fully function application, source code is included!

Use Google Script to easily build amazing applications that can power up your work!

Increase the power of your favorite Google apps — like Docs, Drive, Gmail, and Sheets.  Apps Script lets you do more with Google. All on a JavaScript like platform located in the cloud, making it easy and familiar to write the code and collaborative to share the code.  Make apps in the cloud that can DO MORE than you could ever imagine with just a few lines of code.

This course will teach you how to build applications that can use built in Google Script Classes and Methods to connect your script with advanced powerful functionality.  

If you know JavaScript you can jump right in and start creating web apps connecting all of your Google application together.   Automate your work you will be amazed at how easy it is to work with Apps Script.

JavaScript is a prerequisite to this course!

Course Lessons will demonstrate how to use Google Script

  • Learn what Google script is and how to write code with it
  • Learn about fetching URL data
  • Connect to APIs and retrieve response data directly into your spreadsheet
  • Connect to the Github API
  • Create a Google Doc with just one line of code 
  • Send emails to via GmailApp
  • Setup up automation with Triggers 
  • Link to other Google apps 
  • GET and POST data to an API
  • Scrape webpage source code into a Google Spreadsheet

Building a Twitter Listener using Google Script

  • Find out about Authenticating your Google Script to the Twitter API
  • Learn about Connecting your Google Sheet with Twitter Data
  • Experience using JSON response data and outputting it into your Google Spreadsheet
  • Explore Setting up a Twitter search popup window
  • Find out about Setting up automation with Triggers
  • Learn how to Debug Tweak and improve your code

Source Code is included for all the applications built within this course!

Taught by an instructor with over 18 years of web development experience.  I'm here to help you learn about Google Scripts and ready to answer any questions you might have.

If you have been looking for a way to track Twitter data or want to learn more about using Google Script this course is for you.  Its a one of a kind course online with source code for a fully functional application included!!!!

You will be amazed at what you can do with Google Scripts, join now to start creating your own applications today.

Who this course is for:
  • Anyone who wants to connect to the Twitter API
  • Web developers
  • Application Developers
  • Social Media data collectors