Technical tutorials and developer guides covering Google Sheets, Apps Script, APIs, and the automation building blocks behind Makeinfo's tools.
← Back to all postsApps Script says the Gmail API has not been used in project X? Enabling it may not be enough. Here's the consent screen and project switch that fixed it.
Understand the difference between E.164 and E.123 phone number formats, when to use each, and how to convert between them for SMS APIs and databases.
Turn Google Sheets into a lightweight database with Apps Script. Learn CRUD operations, API endpoints, structured queries, and when to use a real database.
Copy-paste regex patterns for validating phone numbers in E.164, US, UK, Indian, and international formats across JavaScript, Python, and Google Sheets.
Learn how to validate, format, and clean phone numbers in Google Sheets using formulas, regex, Apps Script, and the E.164 standard.
Learn 3 ways to send emails directly from Google Sheets — Apps Script, Google Forms triggers, and add-ons. Includes templates and code examples.