A recent project involved pulling payments, invoices and accounting data from QuickBooks online into a Google Spreadsheet in near real-time.
This example shows how you can easily send email messages with file attachment using the Gmail API.
The previous example shows how to convert Google Sheets to XLS format using the Google Drive API.
An organisation is running on Google Apps and, as part of a branding exercise, they need to update the profile pictures of all Gmail users.
Google Apps allows domain administrators to update the Gmail signatures programatically. This helps you maintain a standard email signature for all users of your organisation but certain fields like employee’s name, email address, title or phone number can be variable.
Gmail sending limits are restricted especially when you are sending emails programatically as in the case of Mail Merge.
The WriteJSONtoSheet method take a JSON object and appends it as a new row in a Google Spreadsheet.
A commonly requested feature of Mail Merge was that users wanted the ability to stop the merge process (and thus the underlying Google Script) after hitting the start button.
The official Google Translate API is available for businesses only but you can use Google Apps Script to create your own Google Language Translation API without having to pay the enterprise license fee.
Given the Amazon ASIN number, the getAmazonSalesRank() method with return the overall Sales Rank of the item using the Amazon Product Advertising API.
Based upon the Twitter RSS Feed, a Maryland based Rails developers has created a Google Script that creates a RSS feed of YouTube videos matching your search terms.
You can store your Microsoft Office files (Word Documents, PowerPoint Presentations and Excel Spreadsheets) in Google Drive in their native format but then it takes up storage space, the files cannot be edited in the cloud and you’ll not be able to embed the files on other web page.
The File.addViewer() or File.addEditor() methods of Google Apps Script allow you to share files in Google Drive programmatically.
The Apps Script Execution API lets you call Google Apps Scripts from standard HTML pages. I’ve been working on a project that involved Apps Script Execution API, it was running perfect in the developer account but as soon as the code was migrated to the client’s Google account, it failed.
Google Drive supports OCR for image and PDF uploads. That means if you upload a, say, JPEG file containing text, Google Drive can automatically extract the text from the image and save it to an editable Google Document.
This code snippet shows how you can use the use the multipart post method to upload a file from Google Drive to Box using the Box API and Google Script.
You can use the OAuth2 library with Google Apps script to connect to the Box API.
The school has a Google Form where teacher enter the performance grades of their students. This form data is stored in a Google Spreadsheet and they are using Google Charts with the Google Visualization API to convert these tables of rows into visual charts that can be easily visualized.
This Google Script, originally published by @rboyd, scans for lengthy emails in your Gmail mailbox (messages that have more than 100 words) and sends an auto-reply requesting the sender to resend the email after editing to less than 100 words.
The GmailApp service of Google Apps Script doesn’t support drafts creation but you use the Gmail API to programatically create drafts in your mailbox.
The Google Documents API doesn’t offer a method to get the number of pages in a document.
Google Docs supports OCR so you can upload a scanned PDF file or an image to Google Drive and it will extract the text from the file.
The Apps Script snippet will insert an image at the current cursor position of the Google Document.
Google Site Search offers a JSON API allowing you to query Google Search results from your app.
Andy Chase has published a Google Script that will let you automatically post Google Form submissions to a Slack channel.
This example shows how you can setup your own Twitter Client using Google Apps Script and publish tweets programmatically from inside a Google Document, a spreadsheet or even a web app.
One of my recent project involved uploading files from Google Drive to a particular bucket in Google Cloud Storage.
The Gmail API offers extra functionality not available inside the Gmail service of Google Apps Script.
The advanced Google Drive API offers access to functionality that is not available with the Drive API inside Google Apps Script.
A mailbox has 1000s of email messages sent though legacy contact forms that contain data like the name, email and address of the senders.