1.22 🔍 How to Create Dynamic Open Graph Images with Google Sheets
Generate Open Graph images dynamically by combining Google Sheets with services like Bannerbear or HTML-to-image APIs. Use Apps Script to call the API with personalized parameters from each row. Automate social cards, blog previews, or product share links based on your data.
1.23 🧪 How to Request Stripe Payments with Google Sheets
Use Stripe’s API via UrlFetchApp.fetch() to create a payment link. Store customer details in your sheet and generate one-click Stripe payments:
UrlFetchApp.fetch("https://api.stripe.com/v1/payment_links", options)
Include your Stripe secret key and payload as JSON in the options object.
1.24 🔍 Convert and Email Google Spreadsheets as PDF Files
Use Apps Script to convert a Google Sheet to a PDF using DriveApp and email it with GmailApp:
var pdf = DriveApp.getFileById(sheetId).getAs("application/pdf");
GmailApp.sendEmail(email, subject, body, {attachments: [pdf]});
1.25 🧪 How to Change the Date Format in Google Sheets
Use the TEXT() formula to change how dates appear:
=TEXT(A1, "dd-mmm-yyyy")
For script-based formatting, use:
Utilities.formatDate(dateObj, Session.getScriptTimeZone(), "MM/dd/yyyy")
1.26 🔍 Find Product Prices in Google Sheets with Vlookup and Match Functions
Use VLOOKUP to find a product’s price:
=VLOOKUP("Product A", A2:C100, 2, FALSE)
Or combine with MATCH() for dynamic column indexing:
=INDEX(A2:C100, MATCH("Product A", A2:A100, 0), MATCH("Price", A1:C1, 0))
1.27 🧪 How to Request Payments with Razorpay and Google Sheets
Use Apps Script to call Razorpay’s payment request API. Create a POST request using your API key:
UrlFetchApp.fetch("https://api.razorpay.com/v1/payment_links", options)
Parse and store the returned payment link in a new column.
1.28 🔍 Essential Date Functions for Google Sheets
Key functions include:
=TODAY() – current date
=NOW() – date + time
=EOMONTH(A1, 1) – end of next month
=DATEDIF(A1, B1, "D") – days between dates
1.29 🧪 How to Use Notion with Gmail and Google Sheets using Apps Script
Use Notion’s API with UrlFetchApp to create pages or update databases. Combine it with GmailApp and Sheet data to log incoming messages or automate dashboards in Notion based on Gmail threads.
1.30 🔍 Sort by Random - How to Randomize the Order of Rows in Google Sheets
Add a helper column with =RAND() next to your data. Then sort the entire range based on that column to shuffle your rows. Recalculate to re-randomize.
1.31 🧪 How to Replace Accented Characters (diacritics) with English letters in Google Sheets
Use Apps Script with Unicode normalization:
text.normalize("NFD").replace(/[\u0300-\u036f]/g, "")
This removes diacritic marks from accented characters like é, ñ, ü.
1.32 🔍 How to Convert Column Number (e.g. 28) to Column Letter (e.g. AB) in Google Sheets
Use a custom Apps Script function:
function numberToColumn(n) {
let letter = "";
while (n > 0) {
let rem = (n - 1) % 26;
letter = String.fromCharCode(65 + rem) + letter;
n = Math.floor((n - 1) / 26);
}
return letter;
}
1.33 🧪 Google Sheets - Find Values in One Column that are Missing in Another Column
Use formulas like:
=FILTER(A2:A100, ISNA(MATCH(A2:A100, B2:B100, 0)))
This returns values in column A that don’t appear in column B.