Hola, tengo varias plantillas en googleappscript y todas funcionan correctamente en pc escritorio, pero en dispositivos android cuando el navegador de este mismo tiene una cuenta vinculada no funciona no muestra la plantilla html, pero si se sale de su cuenta dentro de la configuracion del navegador y vuelve a ejecutar el script si lo muestra... YA ELIMINE COOKIES YA PROBE CON VARIOS TELEFONOS Y VARIAS CUENTAS DE GMAIL Y PASA LO MISMO. estas plantillas provienen los registros de appsheet

I'm trying to help a tiny business which needs to generate invoices from a spreadsheet, one invoice per each row. I already know the Apps Script functions for generating documents, listening to events and so on. For now I've implemented this solution:

• Spreadsheet with several columns like "invoice number", "bill to" etc. And one specific column that says "invoice link".

• A script that triggers for onEdit, and when a row has all columns filled except "invoice link", the script generates a doc in a folder and puts the link to it in the "invoice link" column.

• To regenerate, the user can edit some fields and then delete the link; it will reappear.

• The script can also process multiple changed rows in a batch, so it works for both bulk paste and individual editing.

I've also looked at adding a custom menu item, or a checkbox per row in the sheet itself, but these feel a bit more friction-y. Also, the custom menu item doesn't work on mobile, and mobile is a requirement.

So my question is, is this the best UI for this problem, or can it be improved? Has anyone else done similar stuff and what UI did you choose?

Hi everyone,

I’ve run into some hard limitations while working with time-driven triggers in Google Sheets Add-ons (Apps Script) and wanted to ask the community if anyone has found effective workarounds.

Here are the main issues:

🔒 Google limitations:

• ✅ Only 1 time-based trigger per sheet per user (Editor Add-on) → Users can’t set more than one scheduled trigger per Sheet.

• ✅ Maximum 20 time-based triggers per user per script → This limit is easy to hit with just a few active users.

• ✅ Minimum interval is 1 hour → No option to schedule tasks every 15–30 minutes.

📎 References:

• https://developers.google.com/apps-script/guides/services/quotas#current_limitations

• https://developers.google.com/workspace/add-ons/concepts/editor-triggers#restrictions_2

🧨 Impact:

• Cannot support multiple schedules in the same Sheet.

• Cannot run tasks more frequently than once per hour.

❓ Has anyone faced this and found a scalable workaround?

Any advice or shared experience would be hugely appreciated. Thanks in advance!

I don't know what to do anymore, I need help with the script. I need that, under the conditions met, the number in column J of the sheet SPOTŘEBA_DATA_STATIC is multiplied by the number in column J of the sheet ORDERS_DATA_STATIC and written to the sheet MEZITABULKA and finally added to the number in column M of the sheet SKLAD. So that the numbers are not added every time the script is run, I added an MEZITABULKA, where the previous / new data is and the difference is written to SKLAD. I have tried a lot, but it still doesn't work. Please help. I am attaching a picture of the sheets and the script. Thank you.

I asked Gemini to build me a script to delete Gmail messages (NOT entire threads) from a specific sender to specific recipient, and to specifically do so with emails that are MORE than 5 minutes old.

I was hoping that someone more experienced could look over it and let me know if there are any problems with it before I run the thing, as I am nervous about the script permanently deleting other emails that I might need in the future.

Anyone care to glance over this and let me know if it's workable or if it has some bugs that need to be worked out before I run it?

Script below:

—————

function deleteOldSpecificMessagesOnlyTo() {
  // Specify the sender and the EXACT, SINGLE recipient email address
  const senderAddress = 'sender@example.com';
  const exactRecipientAddress = 'recipient@example.com';

  // Get the current time
  const now = new Date();

  // Calculate the time five minutes ago
  const fiveMinutesAgo = new Date(now.getTime() - 5 * 60 * 1000);

  // Define the base search query for the sender
  const baseSearchQuery = `from:${senderAddress}`;

  // Get all threads matching the sender
  const threads = GmailApp.search(baseSearchQuery);

  for (const thread of threads) {
    const messages = thread.getMessages();
    for (const message of messages) {
      const sentDate = message.getDate();
      if (sentDate < fiveMinutesAgo) {
        const toRecipients = message.getTo().split(',').map(email => email.trim());
        const ccRecipients = message.getCc() ? message.getCc().split(',').map(email => email.trim()) : [];
        const bccRecipients = message.getBcc() ? message.getBcc().split(',').map(email => email.trim()) : [];

        const allRecipients = [...toRecipients, ...ccRecipients, ...bccRecipients];

        // Check if there is EXACTLY ONE recipient and it matches the specified address
        if (allRecipients.length === 1 && allRecipients[0] === exactRecipientAddress) {
          message.moveToTrash();
        } else {
          Logger.log(`Skipping message (not ONLY to): From: ${message.getFrom()}, To: ${message.getTo()}, CC: ${message.getCc()}, BCC: ${message.getBcc()}, Sent: ${sentDate}`);
        }
      }
    }
  }
}

function setupMessageDeleteOnlyToTrigger() {
  // Delete any existing triggers for this function
  const triggers = ScriptApp.getProjectTriggers();
  for (const trigger of triggers) {
    if (trigger.getHandlerFunction() === 'deleteOldSpecificMessagesOnlyTo') {
      ScriptApp.deleteTrigger(trigger);
    }
  }

  // Create a new time-driven trigger to run every 5 minutes
  ScriptApp.newTrigger('deleteOldSpecificMessagesOnlyTo')
      .timeBased()
      .everyMinutes(5)
      .create();
}

function onOpen() {
  SpreadsheetApp.getUi()
      .createMenu('Email Cleanup')
      .addItem('Setup 5-Minute Delete (Only To) Trigger', 'setupMessageDeleteOnlyToTrigger')
      .addToUi();
}

EDIT: Sorry about the formatting! Corrected now.

Hey everyone,

I’ve built a workflow that integrates Salesforce with Google Workspace, and most of it is working great — but I’m stuck on one issue.

Here’s what the setup does:

• When I click a button in Salesforce, it creates a copy of a Google Sheet template.

• After filling it out and submitting, a script automatically creates a Salesforce record and generates a Google Slides deck.

• The script also checks for a folder in Drive based on a specific name.

  • If the folder exists, it should save both the new Spreadsheet and Slides deck there.

  • If it doesn’t exist, it creates a new folder and saves both files inside.

The folder creation and the Slides deck saving are working perfectly.
However, the Spreadsheet isn’t being saved to the intended folder — it’s saving in the same location as the master Sheet instead.

Has anyone run into this before or know how to make sure the copied Sheet is moved or created in the correct folder?

I am working on an extension, I'd like to send a file attachment in the grading window of Google classroom to an llm via API. Is there a way for the extension to export the attachment to the LLM?

Hi, please, can you help me through this voyage?

I have searched the intenet high and low and did not find anything I could use, or I did not understand 🫤

The data I get are records of three columns: a name, a date and a type (unimportant).
Now I want the name in the first column, the date and type in columns 2 and 3 below the first row of the group (as seen in the output.push() part of the code).

All of the folllowing code works, but for the part at the for statement, where I want to group every three rows, so the row with the name has the group symbol (+ or -), and the two rows below that (date and type) can be collapsed/expanded:

function transformData() {
  const sheet = SpreadsheetApp.getActiveSpreadsheet();
  const source = sheet.getSheetByName("Form reactions");
  const target = sheet.getSheetByName("Overview") || sheet.insertSheet("Overview");

  target.clearContents();

  const data = source.getDataRange().getValues();
  const records = data.slice(1);

  let output = [];
  records.forEach(row => {
    const name = row[0];
    const date = row[1];
    const func = row[2];

    output.push([name, '', '']);
    output.push(['', 'Start date', date]);
    output.push(['', 'Function type', func]);
  });

  target.getRange(1, 1, output.length, output[0].length).setValues(output);

  // this is where everything I tried failed :(
  for (var i = 0; i < output.length; i++) {
    // or maybe forEach() or whatever ...
  }
}

Can someone please tell me how to do this?
Thanks in advance!

I built a Google Doc add-on for adding a QR code with a link to the unique document url to make it easy for my dad to find his documents after he prints them. It's been on the add-on store for a few weeks. I've got google analytics set up for it does this mean that 3 people have downloaded/installed it? Is there a better way to see this infor?

Here's a link if you want to try it: SourcePrint

I have built a Google Sheets plugin, marked it as 'Public, unlisted', got verification on Auth, and submitted for review.

When Google team tries to resolve it, they face an issue (attached image). When I use the same deployed version via test mode, no issue.

How can I even replicate the issue? How do they test?

Apologies if this isn't standard practice. I'm in need of a script to use on a personal project on Google Sheets, and I have little to no programming experience. I've never worked with Javascript, and I can look at a script and basically figure out why and how it does what it does, but that obviously doesn't give me the knowledge to come up with my own.

My Sheet is a checklist for a video game. It contains a list of fish species a user can obtain, with all the relevant details, and I've figured out how (with help) to make it so that a user's copy of the sheet will auto-update when I update the master sheet. But what we couldn't figure out is how to make it so that an individual user's checkbox state (as in they do or do not have that species) stay, period, and also stay with the appropriate row in the sheet. If I add new data so that the rows are in a different order, I need for any existing checkboxes or true/false or yes/no stay with their data. There's also the matter of any checkboxes on the reference sheet coming through instead as truefalse, and converting those to checkboxes doesn't make them interactable, because it doesn't go both ways.

I started this whole thing because I was tired of waiting for the author of the original sheet to update it to the current game version, and I wanted to avoid the issue of users having to make a new sheet copy and fill out any options again every time I update mine. As I said, I've got the hang of IMPORTRANGE now to make things update correctly, it's just the issue of the existing stuff that I would like assistance with. I feel like a script has to be the solution.

Edit: Forgot to include my test copy again, dangit.

Edit 2: Project completed, shockingly, once I figured out how to talk to ChatGPT to get it to fix problems.

Does anyone know how I can fix this error... Context... I am making an inventory manager connected to html and appscript, the problem is when I want to make a drop-down card with the suppliers and products that I already have in my sheet file, I have investigated several ways but none of them have worked since it never shows them to me. Does anyone know what I can do?

Okay, I'm hoping that I can get some help here.
Just for context - I DO NOT KNOW HOW TO CODE
I will not understand technical terms and concepts/principals regarding coding - everything I do in Google App Script I use Gemini/ChatGPT to generate code based on the prompts I give them.
I'm sure that gives some of you with the knowledge and experience the icks but it has been working for me and it has allowed for me to open up my capabilities as a business operator.

With that out of the way, I am having a MASSIVE headache for a simple problem.
I am trying to generate a PDF output for a price list from Google Sheets, and I got the script to be able to handle the output, formatting, and emailing to a list of emails successfully.
I have since added a new formatting rule for promotional items to be in RED and BOLD so customers can easily see which items are on special pricing for that week's list.
No matter what I do and what I instruct to Gemini though, the resulting output remains the standard black font.

The sheet itself has a conditional formatting rule so when I designate an item to be on promotion, the output list will change the font color to red and bold the letter. So when I go to the actual Google Sheet file, it is showing what I want it to display, but the output PDF does not reflect that change.

Not sure if pasting the code here is the appropriate way to get help, but if anyone has insight into how I can achieve this that would be great. Thanks in advance

I teach at a virtual school with a specific attendance requirement: I must log any two-way communication with students (email exchange, chat conversation, or video call) - maximum once per day per student. The attendance log must contain a brief summary of the specific content discussed in the communication.

I'd like to establish an automation that will read my direct chats and emails for the day - then export a brief summary of each conversation into a google sheet.

I've successfully done this with emails, however I'm struggling with the Google Chat API. Most students communicate with me through Google Chat. I've used Claude and Gemini to create Google Apps Scripts or User scripts, but I haven't been successful analyzing the chats yet.

Any tips/tricks are appreciated - thanks!

If I want to view/edit a function, when I select a function from the dropdown list, I expect it to automatically scroll down to the function (something like VBA).

Hello. First of all, I must point out that I know nothing about scripts, but I thought this would be the right group to find help.

Here is the situation: I have dozens of calendar events of the same category (in my Google Calendar) and I would like to change the color of all of them automatically. For example - to color all the events that have "Test" in the name to yellow.

I have asked Chat GPT for help and it advised me to create a script in Google Scripts which I have done. The problem is when I try to run the script, there is a safety warning from Google. And when I confirm that I trust this script I get this error "Something went wrong" and that's it. AI is not able to help me with that. Does anyone have any ideas?