1.82 🔍 Send Personalized Tweets & DMs in Bulk from a Google Spreadsheet
Use Twitter’s API (via Apps Script and OAuth1) to send tweets or DMs in bulk. Example Apps Script snippet:
// Use Twitter API to send a DM
var payload = {
event: {
type: "message_create",
message_create: {
target: { recipient_id: "USER_ID" },
message_data: { text: "Hello from Google Sheets!" }
}
}
};
// Use UrlFetchApp.fetch() with OAuth headers to send request
Loop through rows to personalize messages per user.
1.83🧪 How to Scrape Google Search Results inside a Google Sheet
Scraping Google is against their terms, but for educational use, use Apps Script with a proxy or Bing:
var html = UrlFetchApp.fetch("https://www.google.com/search?q=Your+Query").getContentText();
var matches = html.match(/<h3.*?>(.*?)<\\/h3>/g);
Use Cheerio or regex cautiously. Always respect robots.txt.
1.84 🔍 Send Self-Destructing Messages with Google Docs
Create a document, share it with a recipient, then revoke access after a set time using Apps Script:
DriveApp.getFileById(docId).addEditor(email);
Utilities.sleep(60000); // 1 minute
DriveApp.getFileById(docId).removeEditor(email);
You can also schedule via triggers or Gmail links.
1.85 🧪Find and Remove Duplicate Rows in Google Sheets
Use this formula to highlight duplicates:
=COUNTIFS(A:A, A2, B:B, B2)>1
To remove them with Apps Script:
let data = sheet.getDataRange().getValues();
let unique = []; let seen = new Set();
data.forEach(row => {
let key = row.join("|");
if (!seen.has(key)) {
seen.add(key); unique.push(row);
}
});
sheet.clear(); sheet.getRange(1,1,unique.length,unique[0].length).setValues(unique);
1.86 🔍 Google Tables for Viewing Large Excel Spreadsheets on the Web
Use Google Tables (or Connected Sheets + BigQuery) to visualize and filter large Excel data online. Import Excel into Sheets or directly into Tables for collaborative dashboards with real-time updates and filters.
1.87 🧪 How to Publish Google Sheets Directly as PDF or Excel Files
Modify the Sheet’s export URL:
https://docs.google.com/spreadsheets/d/{ID}/export?format=pdf
https://docs.google.com/spreadsheets/d/{ID}/export?format=xlsx
You can also automate this with Apps Script and UrlFetchApp to generate and email exports on demand.