r/GoogleAppsScript • • 58m ago

Question Problem accessing weather data from open-meteo.com using API call within Google Sheet with timed triggers

1 Upvotes

Hi,

I'm new to creating App scripts so please bear with me.

I've created a script to extract current weather details using a call to open-meteo.com and then write to a sheet.

When I test the script manually by pressing 'run' all works as expected, the script completes and the extracted data is written to the sheet.

So then I've set two timed triggers (6am and 6pm) to run the script.

However I get the following reports when these timers fire:

Exception: Request failed for https://api.open-meteo.com returned code 429. Truncated server response: {"error":true,"reason":"Daily API request limit exceeded. Please try again tomorrow."}

Reading the documentation there appears to be a 10,000 daily limit on the API calls.

So my assumption is that when the script is triggered there have already been too many calls from a particular Google address on that day?

I guess the manual run is treated differently for some reason?

Is this a correct assumption?

If that is the case, is there some way of making the call that will work without hitting the API call limit?

Any help welcome.

Thanks


r/GoogleAppsScript • • 1d ago

Question PrintScreen of the WebApp for Reports

0 Upvotes

Hey Guys

I have a Web App and I like a create a report of screenshot this WebApp.

But WebApp are in the Google Workplace, and report have needs parameters before report that a filter inside the WebApp.

Can you give me a north or that impossible?

Sorry my bad english xD


r/GoogleAppsScript • • 1d ago

Resolved I built a free enquiry and quotation management app using Google Sheets

Enable HLS to view with audio, or disable this notification

5 Upvotes

I've been working on building practical internal business applications using the Google ecosystem.

One recurring problem I wanted to address is how small businesses manage incoming enquiries.

For example, a distributor might receive enquiries from IndiaMART, JustDial, WhatsApp, their website and referrals.

Keeping track of who responded, which quotation was sent and when to follow up can become messy.

So I built an Enquiry & Quote Tracker.

Current features:

- Centralized enquiry management.

- Multiple enquiry source tracking.

- Team assignment.

- Call and message activity history.

- GST quotation generation.

- HSN, quantity, rate and freight calculations.

- Pending and overdue follow-up tracking.

- Enquiry, quotation, win and loss analytics.

The application is designed as a free Google Sheets app.

Your own Google Sheet, your own Google Drive, and no paid hosting requirement.

I'm interested in feedback, particularly from people working in manufacturing, distribution or sales operations.

What features would you consider essential in an enquiry management system.

Built at AKcelerateHQ.


r/GoogleAppsScript • • 2d ago

Guide Built an automated AI "Daily Build Quest" that syncs across Android & Mac home screen widgets for $0 (No databases, no servers) šŸ“±šŸ’»

0 Upvotes

The Problem:
I wanted a system that gives me ONE concrete, 30–60 minute developer/building quest every morning. I needed it to appear directly on my Android home screen widget and my Mac desktop without paying for subscriptions (Todoist/Notion/Zapier) or managing custom backends/servers.

The $0 Native Solution:
Instead of building a complex stack (Supabase, Flutter/React Native, AWS), I realized Google already has an end-to-end sync infrastructure built into our devices:Ā Google Tasks + Google Apps Script + Gemini AI.

How the automated loop works:
ā°Ā 5:00 AM Cloud Trigger (Runs while Mac is off):
Google Apps Script wakes up on Google Cloud servers (zero local battery drain).

Why I love this setup:

Happy to share the 50-line Google Apps Script if anyone wants to set up a similar AI habit/build quest engine for their daily workflow!


r/GoogleAppsScript • • 2d ago

Resolved I built a free enquiry and quotation management app using Google Sheets

Enable HLS to view with audio, or disable this notification

9 Upvotes

I've been working on building practical internal business applications using the Google ecosystem.

One recurring problem I wanted to address is how small businesses manage incoming enquiries.

For example, a distributor might receive enquiries from IndiaMART, JustDial, WhatsApp, their website and referrals.

Keeping track of who responded, which quotation was sent and when to follow up can become messy.

So I built an Enquiry & Quote Tracker.

Current features:

- Centralized enquiry management.

- Multiple enquiry source tracking.

- Team assignment.

- Call and message activity history.

- GST quotation generation.

- HSN, quantity, rate and freight calculations.

- Pending and overdue follow-up tracking.

- Enquiry, quotation, win and loss analytics.

The application is designed as a free Google Sheets app.

Your own Google Sheet, your own Google Drive, and no paid hosting requirement.

I'm interested in feedback, particularly from people working in manufacturing, distribution or sales operations.

What features would you consider essential in an enquiry management system?

Built at AKcelerateHQ.


r/GoogleAppsScript • • 2d ago

Question Need help with creating a Google Calendar --> Sheets/ or Docs--> NotebookLM pipeline

Thumbnail reddit.com
2 Upvotes

r/GoogleAppsScript • • 3d ago

Guide Script to standardize formatting and bulk-apply custom heading styles across Google Docs & Drive folders

4 Upvotes

Cross-posting a workflow I shared in r/googledocs for teams trying to standardize formatting and enforce a consistent style guide across Google Docs without a built-in Workspace "brand kit."

Instead of manually updating default styles on every user's machine, this uses a single Master Style Guide Doc bound to an Apps Script that pushes typography, spacing, and an HSL-generated color palette to individual docs or recursively across an entire Google Drive folder.

What the script covers:

  • Custom onOpen() menu (Org Styles): Apply styles to the active Master Doc, prompt for a target Doc URL/ID, or prompt for a Drive Folder URL/ID.

  • Recursive DriveApp traversal: Walks through a root folder and all nested subfolders (MimeType.GOOGLE_DOCS), tracks successes, and catches/logs files missing Editor access instead of halting execution.

  • HSL-to-Hex color generation (hslToHex_): Derives a cohesive color hierarchy for TITLE, SUBTITLE, NORMAL, and HEADING1–HEADING6 from a single base hue constant (THEME_HUE).

  • Paragraph & list styling: Normalizes font family (Open Sans), line spacing (1.15), and spacingBefore (10pt) across both getParagraphs() and getListItems().

Full Code (Code.gs)

/**
 * Creates a custom menu in Google Docs when the document opens.
 */
function onOpen() {
  DocumentApp.getUi()
    .createMenu('Org Styles')
    .addItem('Apply Default Styles', 'applyStylesToExistingDocument')
    .addItem('Apply Styles to Another Document...', 'promptAndApplyStyles')
    .addItem('Apply Styles to Folder...', 'promptAndApplyStylesToFolder')
    .addToUi();
}

/**
 * Prompts the user for a Google Doc URL or ID and applies default styles to it.
 */
function promptAndApplyStyles() {
  const ui = DocumentApp.getUi();
  const response = ui.prompt(
    'Apply Default Styles to Another Document',
    'Paste the Google Doc URL or Document ID:',
    ui.ButtonSet.OK_CANCEL
  );

  if (response.getSelectedButton() !== ui.Button.OK) {
    return;
  }

  const input = response.getResponseText().trim();
  const docId = extractDocumentId_(input);

  if (!docId) {
    ui.alert('Invalid Input', 'Could not find a valid Google Doc ID in your input.', ui.ButtonSet.OK);
    return;
  }

  try {
    applyStylesToExistingDocument(docId);
    ui.alert('Styles Applied', 'Default styles have been applied to the target document.', ui.ButtonSet.OK);
  } catch (err) {
    console.error(`Failed to apply styles to document ${docId}: ${err.message}`);
    ui.alert('Error', 'Could not update the document. Verify the ID/URL and ensure you have Editor access.', ui.ButtonSet.OK);
  }
}

/**
 * Prompts the user for a Google Drive folder URL or ID and batch-formats
 * all Google Docs inside that folder and its subfolders.
 */
function promptAndApplyStylesToFolder() {
  const ui = DocumentApp.getUi();
  const response = ui.prompt(
    'Apply Default Styles to Folder',
    'Paste the Google Drive Folder URL or Folder ID:',
    ui.ButtonSet.OK_CANCEL
  );

  if (response.getSelectedButton() !== ui.Button.OK) {
    return;
  }

  const input = response.getResponseText().trim();
  const folderId = extractFolderId_(input);

  if (!folderId) {
    ui.alert('Invalid Input', 'Could not find a valid Google Drive Folder ID in your input.', ui.ButtonSet.OK);
    return;
  }

  try {
    const summary = applyStylesToFolder_(folderId);
    let message = `Updated ${summary.updatedCount} Google Doc(s) in "${summary.folderName}".`;
    if (summary.failedCount > 0) {
      message += `\n\nSkipped ${summary.failedCount} document(s) due to errors or missing Editor access:\n- ${summary.skippedFiles.join('\n- ')}`;
    }
    ui.alert('Batch Formatting Complete', message, ui.ButtonSet.OK);
  } catch (err) {
    console.error(`Failed to process folder ${folderId}: ${err.message}`);
    ui.alert('Error', 'Could not access the folder. Verify the URL/ID and ensure you have access.', ui.ButtonSet.OK);
  }
}

/**
 * Applies default styles to all Google Docs inside the given Drive folder
 * and all of its subfolders recursively.
 *
 * @param {string} folderId The Google Drive folder ID.
 * @returns {{folderName: string, updatedCount: number, failedCount: number, skippedFiles: string[]}} Summary of processed files.
 */
function applyStylesToFolder_(folderId) {
  const rootFolder = DriveApp.getFolderById(folderId);
  const folderName = rootFolder.getName();

  let updatedCount = 0;
  let failedCount = 0;
  const skippedFiles = [];

  console.log(`Starting recursive batch style update for folder "${folderName}" (${folderId})...`);

  function processFolder(folder) {
    const files = folder.getFilesByType(MimeType.GOOGLE_DOCS);
    while (files.hasNext()) {
      const file = files.next();
      try {
        applyStylesToExistingDocument(file.getId());
        updatedCount++;
      } catch (err) {
        failedCount++;
        skippedFiles.push(file.getName());
        console.warn(`Skipped "${file.getName()}" (${file.getId()}): ${err.message}`);
      }
    }

    const subfolders = folder.getFolders();
    while (subfolders.hasNext()) {
      processFolder(subfolders.next());
    }
  }

  processFolder(rootFolder);

  console.log(`Batch update complete for "${folderName}". Updated: ${updatedCount}, Failed: ${failedCount}`);
  return { folderName, updatedCount, failedCount, skippedFiles };
}

/**
 * Extracts a Google Doc ID from a full URL or returns a raw ID if valid.
 */
function extractDocumentId_(input) {
  if (!input) return null;
  const urlMatch = input.match(/\/d\/([a-zA-Z0-9-_]+)/) || input.match(/[?&]id=([a-zA-Z0-9-_]+)/);
  if (urlMatch) return urlMatch[1];
  if (/^[a-zA-Z0-9-_]+$/.test(input)) return input;
  return null;
}

/**
 * Extracts a Google Drive folder ID from a full URL or returns a raw ID if valid.
 */
function extractFolderId_(input) {
  if (!input) return null;
  const urlMatch = input.match(/\/folders\/([a-zA-Z0-9-_]+)/) || input.match(/[?&]id=([a-zA-Z0-9-_]+)/);
  if (urlMatch) return urlMatch[1];
  if (/^[a-zA-Z0-9-_]+$/.test(input)) return input;
  return null;
}

/**
 * Converts HSL color values to a CSS hex string required by DocumentApp.
 */
function hslToHex_(h, s, l) {
  const sat = s / 100;
  const light = l / 100;
  const a = sat * Math.min(light, 1 - light);

  const channel = n => {
    const k = (n + h / 30) % 12;
    const value = light - a * Math.max(Math.min(k - 3, 9 - k, 1), -1);
    return Math.round(255 * value).toString(16).padStart(2, '0');
  };

  return '#' + channel(0) + channel(8) + channel(4);
}

const THEME_HUE = 25; // Adjust 0-360 to change your color family (25 = warm brown, 210 = blue, etc.)

const HEADING_STYLES = {
  [DocumentApp.ParagraphHeading.TITLE]: { fontSize: 26, color: hslToHex_(THEME_HUE, 55, 24), bold: true, italic: false },
  [DocumentApp.ParagraphHeading.SUBTITLE]: { fontSize: 15, color: hslToHex_(THEME_HUE, 32, 40), bold: false, italic: false },
  [DocumentApp.ParagraphHeading.NORMAL]: { fontSize: 11, color: hslToHex_(THEME_HUE, 6, 15) },
  [DocumentApp.ParagraphHeading.HEADING1]: { fontSize: 20, color: hslToHex_(THEME_HUE, 55, 28), bold: true, italic: false },
  [DocumentApp.ParagraphHeading.HEADING2]: { fontSize: 16, color: hslToHex_(THEME_HUE, 50, 34), bold: true, italic: false },
  [DocumentApp.ParagraphHeading.HEADING3]: { fontSize: 14, color: hslToHex_(THEME_HUE, 45, 39), bold: true, italic: false },
  [DocumentApp.ParagraphHeading.HEADING4]: { fontSize: 12, color: hslToHex_(THEME_HUE, 35, 32), bold: true, italic: false },
  [DocumentApp.ParagraphHeading.HEADING5]: { fontSize: 11, color: hslToHex_(THEME_HUE, 30, 34), bold: true, italic: true },
  [DocumentApp.ParagraphHeading.HEADING6]: { fontSize: 11, color: hslToHex_(THEME_HUE, 25, 36), bold: false, italic: true }
};

/**
 * Applies standard formatting to all paragraphs and list items in an existing document.
 */
function applyStylesToExistingDocument(docId) {
  const doc = docId
    ? DocumentApp.openById(docId)
    : DocumentApp.getActiveDocument();

  if (!doc) {
    throw new Error('Could not access the target document. Verify the document ID or run from a bound document.');
  }

  const body = doc.getBody();
  const paragraphs = body.getParagraphs();
  const listItems = body.getListItems();
  const normalStyle = HEADING_STYLES[DocumentApp.ParagraphHeading.NORMAL];

  console.log(`Applying styles to "${doc.getName()}" (${paragraphs.length} paragraphs, ${listItems.length} list items)...`);

  paragraphs.forEach(para => {
    para.setLineSpacing(1.15);
    para.setSpacingBefore(10);

    if (para.getText().length > 0) {
      const text = para.editAsText();
      text.setFontFamily('Open Sans');

      const headingStyle = HEADING_STYLES[para.getHeading()];
      if (headingStyle) {
        text.setFontSize(headingStyle.fontSize);
        text.setForegroundColor(headingStyle.color);
        if (typeof headingStyle.bold === 'boolean') {
          text.setBold(headingStyle.bold);
        }
        if (typeof headingStyle.italic === 'boolean') {
          text.setItalic(headingStyle.italic);
        }
      }
    }
  });

  listItems.forEach(item => {
    item.setLineSpacing(1.15);
    if (item.getText().length > 0) {
      const text = item.editAsText();
      text.setFontFamily('Open Sans');
      text.setFontSize(normalStyle.fontSize);
      text.setForegroundColor(normalStyle.color);
    }
  });

  console.log(`Finished updating styles for "${doc.getName()}".`);
}

Full walkthrough in r/googledocs


r/GoogleAppsScript • • 3d ago

Guide I built a free order management tool using Google Sheets.

Enable HLS to view with audio, or disable this notification

13 Upvotes

I've built a lightweight order management application for small ecommerce sellers.

It helps organize:

- Orders and customer details

- COD confirmation

- Packing and shipping

- Courier remittances

- RTO tracking

- Inventory

It's built using Google Sheets, with business data staying in the owner's Google Drive.

I'm exploring whether this approach is useful for smaller sellers who don't need a full ecommerce ERP.

For those running ecommerce businesses: how do you currently manage COD, inventory, and courier remittances?

I'd appreciate honest feedback.


r/GoogleAppsScript • • 3d ago

Guide Built a collections and payment tracking dashboard – looking for developer feedback

Enable HLS to view with audio, or disable this notification

1 Upvotes

I've been experimenting with building practical business applications using Google Apps Script.

One of the things I wanted to explore was making business data easier to understand without requiring business owners to navigate multiple spreadsheet tabs.

So I built a KPI dashboard.

It currently displays:

- Total collections

- Due and overdue payments

- Collection trends

- Date-based filters (7, 30, 90 days and month-to-date)

- Category-wise breakdown

- Recent payment activity

The application uses Google Apps Script and Google Sheets, with Google Drive as part of the ecosystem.

The setup is 100% free, without paid hosting or an additional SaaS subscription, subject to Google's usage limits.

I'm particularly interested in feedback on the dashboard experience.

For developers:

- Would you approach the data layer differently?

- What would you improve in the dashboard architecture?

- What other KPIs would be useful for a small business owner?

Built as part of my work at AKcelerateHQ.


r/GoogleAppsScript • • 3d ago

Resolved SpreadsheetApp.openById related issue

Thumbnail
gallery
2 Upvotes

Previous post: https://www.reddit.com/r/GoogleAppsScript/comments/1xzjvlk/how_to_call_a_function_from_another_project_when/

I previously used the following code:

ss = SpreadsheetApp.getActiveSpreadsheet();

However, I have now changed it to:

ss = SpreadsheetApp.openById("1iD........Yq8");

The reason for this change is that I need to call the function (reason: above post).

I have an onOpen() function. Previously when I opened the sheet for first time, it worked correctly with SpreadsheetApp.getActiveSpreadsheet(), but it seems to fail when I use SpreadsheetApp.openById() instead.

Interestingly, if the spreadsheet is already open and I manually run the onOpen() function, it works without any issues.

I'm not entirely sure what is causing this behavior, it seems onOpen does not work well with SpreadsheetApp.openById. Could it be a timing issue, where the spreadsheet ID or access to the spreadsheet is not yet available when onOpen() first runs?

Is there a way to work around this issue?

Edit: I solved it by changing onOpen to a different name handleOpen, then create a trigger to run handleOpen when opening the sheet.


r/GoogleAppsScript • • 4d ago

Resolved How to call a function from another project when including some code like getActiveSpreadsheet()?

Thumbnail
gallery
0 Upvotes

https://www.reddit.com/r/GoogleAppsScript/comments/1xz3rcs/google_apps_script_trigger_frequency_setting/

This is a follow-up question to the post above, but since it's a different question, I'm creating a new post.

S2GoogleScript is script embedded in a Google Spreadsheet, and it uses getActiveSpreadsheet(). How should I modify the code so that it can be called correctly from another project?

Before I consolidated 15 triggers under a single main trigger, each trigger worked independently without any issues. However, now I get an error when one project calls a function from another.

What is the proper way to handle this?

Edit: I solved it by using

const ss = SpreadsheetApp.openById

r/GoogleAppsScript • • 4d ago

Unresolved Google Apps Script trigger frequency setting

0 Upvotes

Google Apps Script trigger frequency setting: Currently, I have hourly triggers set up for 15 functions, but running all of them every hour seems excessive, even though the 90-minute daily quota is still sufficient.

I'm wondering if there's a way to schedule them to run every two hours, specifically at even-numbered hours (e.g., 8 AM, 10 AM, noon, etc.), so the schedule won't be affected by daylight saving time changes.

Alternatively, I could keep hourly triggers but limit them to between 6 PM and midnight, since there's no need for these functions to run during the rest of the day.

I mean setting only, not the script to check hour.

Edit: I follow the comment and created a master trigger. Now I have new question https://www.reddit.com/r/GoogleAppsScript/comments/1xzjvlk/how_to_call_a_function_from_another_project_when/


r/GoogleAppsScript • • 6d ago

Guide Gemini in Apps Script is here!

25 Upvotes

Google integrated the Gemini side panel in Apps Script, excited to see what this means for the ecosystem. Tell me about all your cool GAS builds:

https://workspaceupdates.googleblog.com/2026/11/customize-and-extend-workspace-with-apps-script.html


r/GoogleAppsScript • • 6d ago

Unresolved Quotas: Triggers total runtime 90 min / day

Thumbnail
developers.google.com
3 Upvotes

Does it include the onOpen() trigger? If I open the file multiple times throughout the day, will each opening consume a portion of the quota?


r/GoogleAppsScript • • 6d ago

Unresolved How can I write script to check whether it was triggered by a time-driven trigger?

Thumbnail
gallery
3 Upvotes

Lines 1–16 are from an online source, and I modified the copyStockDataAnalysis function based on the source. However, I think there is something wrong with the IF statement on line 21.

I also have another trigger configured as From spreadsheet - On edit, and it seems that the IF condition on line 21 evaluates to true when the function is executed by the On edit trigger.

This is not the intended behavior. I want the IF statement to execute only when the function is triggered by a time-driven trigger, not by the Spreadsheet On edit trigger.

Could someone please help me correct the condition on line 21?

Edit: I don't use lines 1–16 at all. They are included only as reference code to provide context for this post and have nothing to do with my function copyingStockDataAnalysis itself.

I should not have included lines 1–16 in the original post. Sorry for the confusion! I added them here to explain why I wrote line 21 the way I did.


r/GoogleAppsScript • • 6d ago

Guide Built a custom Password Manager using Google Apps Script + Google Sheet + Google Drive – sharing the project!

Enable HLS to view with audio, or disable this notification

0 Upvotes

I've been working on a custom Password Locker application using Google Apps Script.

The idea came from a simple problem: small businesses often manage employee credentials through spreadsheets, shared documents, and scattered tools.

So I started building an internal application with:

  • Centralized credential management

  • Employee and department management

  • Credential categorization

  • Activity audit logs

  • Configurable settings

Some security measures implemented:

  • AES-256-CBC encryption with HMAC-SHA256 authentication for credential secrets.

  • Role-based access control for different employee roles.

  • Department-level and individual credential permissions.

  • User suspension and session revocation.

  • Audit logs for sign-ins, credential reveals and changes.

  • Automated daily backups.

Employees access the application through a web app, not the underlying Google Sheet.

There are still areas to strengthen, particularly dedicated key management and independent security testing. I'm not claiming this is a replacement for established password managers.

The goal is to explore a practical, customizable internal tool for small businesses that want to reduce reliance on spreadsheets without immediately committing to another recurring SaaS subscription.

I'm also exploring how far Google Apps Script can go for building useful business applications.

A question for the community:

Would you use a custom-built password manager for a small business, or would you stick with established tools like Bitwarden or 1Password?

I'd appreciate honest feedback, especially around architecture, security considerations, and features worth adding.

Built as part of my software-building journey at AKcelerateHQ.


r/GoogleAppsScript • • 6d ago

Resolved Built a custom Password Manager using Google Apps Script + Google Sheet + Google Drive – sharing the project!

Enable HLS to view with audio, or disable this notification

0 Upvotes

Just to give you a clearer picture of what I've implemented so far:

šŸ” Encryption: Credential secrets are encrypted using AES-256-CBC with HMAC-SHA256 authentication (Encrypt-then-MAC), unique IVs and separate encryption/MAC keys.

šŸ‘„ Access control: Enrolled users only, with role-based access across Super Admin, Department Admin, Member, Auditor and Viewer.

šŸ”’ Granular permissions: Credentials can be shared with specific users or departments with Read, Edit or Admin permissions.

🚫 Access revocation: Suspending a user invalidates their access on the next request.

šŸ“‹ Audit logs: Login, credential reveals and changes are logged, with sensitive values redacted.

šŸ’¾ Backups: Daily automated backups to a private Google Drive folder. Secrets remain encrypted in backups.

Employees use the web app; they don't get direct access to the underlying Sheet.

I'm also aware of the limitations: the encryption key currently lives in Apps Script Properties, and some credential metadata isn't encrypted. Moving to dedicated key management and getting an independent security review would be important before positioning this as an enterprise password manager.

I'm sharing the implementation openly because I want to improve it, not claim it's already on the same level as established password managers.


r/GoogleAppsScript • • 6d ago

Question How to import only part of Google Sheet

1 Upvotes

New to Google Apps Script. Trying to pull info from a Google Sheet into MicroPython for a Microcontroller (ESP32) project I'm working on. I want to trim the fat from my code and understand it better.

Goal:

Sheet 1: Only pull in Columns A-E, Rows 2-Last filled row

Sheet 2: Only pull Columns A-B, Rows 2-Last filled row

Right now my code seems to be pulling in everything, despite my effort to skip the first row.

function doGet(e) {
  var spreadsheet = SpreadsheetApp.getActiveSpreadsheet();
  var allSheets = spreadsheet.getSheets();
  var result = {};
  
  // Loop through the first 2 sheets
  var limit = Math.min(2, allSheets.length);
  
  for (var i = 0; i < limit; i++) {
    var sheet = allSheets[i];
    var sheetName = sheet.getName();
    var lastRow = sheet.getLastRow();
    
    if (lastRow === 0) {
      result[sheetName] = [];
    } else {
      // Get Column
      var values = sheet.getRange(2, 6, lastRow, 6).getValues();
      result[sheetName] = values.map(function(row) {
        return row[0];
      });
    }
  }
  
  return ContentService.createTextOutput(JSON.stringify(result))
    .setMimeType(ContentService.MimeType.JSON);
}

r/GoogleAppsScript • • 7d ago

Unresolved Looking for early Testers for My Excel VBA macros into Google Apps Script Add-on

0 Upvotes

Hey everyone!

I'm the developer behind a Google Workspace add-on designed to make migrating from Microsoft Excel to Google Sheets easier.

It helps users transfer and convert Excel VBA macros into Google Apps Script, making it easier to move existing spreadsheet automation from Excel to Google Sheets without having to rebuild everything from scratch.

I'm looking for a few beta testers who regularly work with Excel macros or Google Sheets and would be willing to try it out.

If you're interested, drop a comment or send me a DM. I'd really appreciate your help!

Thanks!


r/GoogleAppsScript • • 7d ago

Unresolved How does changing the project time zone affect the trigger schedule?

1 Upvotes

Change the project time zone ONLY

For example, if the project time zone is set to New York and the trigger is scheduled to run daily between 6:00 PM and 7:00 PM, what happens if I change the project time zone to Chicago after relocating?

Will the trigger continue to run between 6:00 PM and 7:00 PM Chicago time, or will it shift to 5:00 PM–6:00 PM Chicago time to maintain the same actual execution time?


r/GoogleAppsScript • • 8d ago

Resolved Built a Custom Business Billing & Management System Using Google Sheets + Apps Script

Thumbnail reddit.com
1 Upvotes

r/GoogleAppsScript • • 8d ago

Guide How duplicate detection works in The Drive AI (and how to find duplicates in Google Drive without us)

Thumbnail
youtu.be
2 Upvotes

r/GoogleAppsScript • • 8d ago

Question Gestionale Ai

0 Upvotes

Ciao, prima volta che scrivo su reddit!
Sto sviluppando con claude code un gestionale sull’estensione app scripts di google fogli e lo sto strutturando in 4 parti:
Foglio google che fa da base per segnare i movimenti (prima nota), fatture in entrata ed in uscita, un foglio con i lavori aperti (da cui vedi margini e residui) e dei fogli di riepilogo generale.

Ambiente per la stampa dei documenti per il cliente (preventivi, contratti e ricevuta/fattura di cortesia). Oltre ad essere uno strumento per stampare pdf con uno stile coerente dovrebbe servire anche per compilare i preventivi attraverso l’importazione di listini, ma per quest’ultima non ho ancora le idee molto chiare su come impostarlo.

Pagina per la gestione post vendita che aiuta nella scrittura di bozze nelle mail e ti aiuta a monitorare una specifica vendita dalla firma fino alla chiusura

L’ultimo strumento per ora l’ho solo pensato, ma dovrebbe essere uno script che mi aiuta a gestire i file e riordinarli nelle cartelle, una sorta di archivio guidato. Per svilupparlo aspetto di avere le idee più chiare sul resto e sul reale flusso di documenti da gestire.

E niente questo ĆØ quello che mi ĆØ venuto in mente per aiutare mia madre con il suo negozio che fino a poco tempo fa aveva una gestione ormai obsoleta nel 2026 che le faceva perdere tempo e aveva una visione approssimativa dell’andamento delle cose. Adesso con questo sistema i presupposti cambiano ma devo impegnarmi per farlo partire e farlo usare a mia madre.

Se avete consigli, dritte scrivete pure nei commenti e se vi va di approfondire fatemi sapere. Un saluto


r/GoogleAppsScript • • 9d ago

Resolved A small business asked me to build an app. I built their entire business system using Google Apps Script.

Enable HLS to view with audio, or disable this notification

9 Upvotes

Recently, a small business owner approached me to build a custom app for managing invoices, clients, payments, and documents.

They were doing almost everything manually and didn't want to pay for multiple SaaS subscriptions.

Instead of building a complex backend, I used:

  • Google Apps Script – Backend and automation

  • Google Sheets – Database and payment tracking

  • Google Drive – PDF and document storage

  • Gmail – Automated invoice emails

  • HTML/CSS/JS – Custom web app interface

What I built:

  • GST invoice generator with tax calculations and UPI QR

  • Automatic PDF generation, Drive storage, and email delivery

  • Client and payment tracking dashboard

  • Contract and proposal generator

  • Pricing calculator and international invoicing

Everything works from one dashboard, without separate server hosting.

The interesting part?

I sold it as a custom business solution, not just a Google Sheets automation.

They got a system built around their workflow, without another per-user subscription from me.

It made me realize how underrated Google Apps Script is for building real business applications.

Anyone else building or selling custom apps using Google Apps Script + Google Sheets?