r/GoogleAppsScript

Is verifying an appscript project taking longer than usual? In the past you could get an app verified in under a week, the longest I waited was 11 days, i have an app that has taken over a month and all the reviewer does is to send some template message complaining about stuff my video already addresses. Are those in the Trust and Safety team audited at all to ensure they are doing the right thing? It is now so frustrating, it is like they dont even know what they are about. Am I the only one experiencing this now? I thought the process will be faster consideting AI does some of the work now.

Hey everyone, I’m working on an automation project for my university schedule and I’m stuck at a super annoying part. Our uni publishes a 4‑month semester calendar as an Excel file on SharePoint. The link is always the same, it’s publicly viewable, no login needed, and you can freely download it.

I’m trying to build a live, reliable automation tool that fetches the latest data and syncs it directly to Google Calendar. The problem is: every time I try to fetch the Excel file programmatically, SharePoint’s “protected file” behavior blocks or redirects the request, even though the file is technically public.

I tried multiple methods, different languages, direct URL fetches, etc. Nothing works consistently because SharePoint keeps interfering.

Right now my workaround is:

• manually download the Excel file
• upload it to Google Sheets
• use Google Apps Script to push updates into Google Calendar

It works, but it’s not “live” and not reliable enough for automation.

Has anyone figured out how to fetch a public SharePoint Excel file without getting blocked? Or any trick to get the raw file URL so I can automate the whole pipeline?

Hello all,

I have a function called onEdit(e), and it works perfectly except for when I attempt to hide a row. The code is below:

function onEdit(e){
  let sheet  = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
  // event variables
  let range = e.range;
  let row = e.range.getRow();
  let col = e.range.getColumn();
  let cellValue = sheet.getActiveCell().getValue();

  let status = sheet.getRange(row,5).getDisplayValue();

  if ( col == 5 && cellValue != 'Problem' && cellValue != 'Not Started') {
    MailApp.sendEmail(email info, this part works);

    if (status == 'Completed') {
      Utilities.sleep(7000);
      sheet.hideRows(row);
    };


  };
}

This is not working, regardless of whether I include the Utilities.sleep command, use sheet.hideRows or sheet.hideRow, or put the command inside or outside the nested if statement.

Any guidance?

I am looking for googlesheet automation experts / freelancers. Please dm if you are an expert.

Work details

There is a base googlesheet with 20 columns. I need 2 buttons in the sheet, each will create a new googlesheet but contain just 15 columns out of the 20. So the 5 columns should be removed.

Compensation

This can be decided based on your hourly rate and the time this project will take

Once this project is done, I have a few more projects lined up.

Think workspace can automate sending a reply to a lead right?

Lately, I’ve been spending more time building local business lead lists, and one thing I’ve learned is that quality matters much more than quantity.

A huge list is easy to build. A clean list with useful, accurate information is much harder.

Right now my process feels too manual, so I’m looking for better ways to improve it.

How are you building quality lead lists?

Recently, I have been assisting in lead generation for a campaign targeting local businesses.

There is plenty of good business data available through mapping services, however the manual extraction and organization of the data has become very tiring.

I am currently researching some software to make this process more efficient.

It would be interesting to hear what others have used.

Hola a todos. Estoy aprendiendo a integrar un formulario HTML/JS local con Google Sheets a través de Google Apps Script (Web App), pero me he topado con las famosos errores de CORS. Alguien me ayuda?

Mi entorno:

• Frontend: Archivo HTML/JS corriendo en un servidor local. He probado con Python (http://127.0.0.1:5500) y con live server de VScode.
• Backend: Un script de Google Apps Script ejecutando una función doPost(e) que añade filas a un Sheets y devuelve un JSON: { status: "ok" }.

Lo que ocurre:

1. Si configuro el fetch con mode: "no-cors", la petición llega a Google Sheets y escribe la fila correctamente, pero el navegador me da una respuesta opaca. Por lo tanto, mi JavaScript se queda "a ciegas" y no puede leer el JSON de respuesta para mostrar un mensaje de éxito o fracaso.
2. Lo curioso es que la fila lo agrega bien con todas sus columnas. pero quiero que emita diferentes mensajes según diferentes casos.
3. Si cambio el fetch a mode: "cors", el navegador bloquea la petición por completo y me saltan los errores de CORS que adjunto en la imagen.

I've built some moderately complex (?) google sheets with Claude extension for Chrome, and it did great, or so I thought, in building them. But there have been bugs, and Claude has been bad at debugging. It spends TONS of time, and uses tons of tokens, poking around taking screen shots and then loses memory regularly when it compresses.

Any suggestions for something will do a better job? I tried CPT in Chrome and it was worthless. Built it in Gemini, the same.

I'm NOT a coder, so the agent has to handle that... it's not just helping.

Thanks.

I'm building a project that automatically converts university timetables from SharePoint Excel files into Google Calendar events, and I've hit a wall with SharePoint automation.

Current workflow:

1. The university publishes the timetable as an Excel file in SharePoint.
2. I manually download the Excel file.
3. Upload it to Google Drive.
4. Convert it into Google Sheets.
5. Use Google Apps Script to parse the timetable data.
6. Generate and update events in Google Calendar.

This prototype actually works.

The problem is that the university updates the timetable regularly. Every update requires manually downloading the new Excel file and uploading it again, which defeats the purpose of automation.

My goal is to create a fully automated system where:

• A student provides a SharePoint timetable link.
• The system automatically fetches the latest timetable.
• Detects timetable changes.
• Updates Google Calendar automatically.
• Works even for non-technical students without requiring manual Excel downloads or uploads.

Things I've already tried:

• Microsoft Graph API
  • Had authentication and permission issues because I don't control the university's Microsoft 365 tenant.
  • Couldn't find a reliable way to access the file consistently.
• Power Automate
  • University restrictions and permissions prevented a practical solution.
  • Didn't seem suitable for a product that should work for any student.

Current challenge:

I need a reliable way to automatically retrieve updated Excel files from SharePoint when I don't control the SharePoint environment.

Questions:

1. Has anyone built something similar with SharePoint-hosted files?
2. Is there a reliable way to monitor a SharePoint Excel file for changes without tenant-level access?
3. How do services like timetable sync tools handle frequently changing SharePoint documents?
4. Would you continue trying Microsoft Graph, or is there a better architecture?
5. Is scraping/downloading the file from a public SharePoint URL a reasonable approach, or is there a more robust solution?

I'm interested in hearing both technical and product-design perspectives because the long-term goal is to make timetable synchronization completely automatic for non-technical students.

Google Calendar’s built-in holiday calendars are read-only ICS feeds, so they don’t allow reminders, labels, or editing. That’s why holidays that move each year (Easter, Yom Kippur, Diwali, Mother’s Day, etc.) can’t be customized from the UI.

I actually ran into the same issue and ended up solving it with Google Apps Script. The script calculates the correct holiday dates each year, avoids duplicates, and adds them to your calendar as normal events. Since they’re real events instead of ICS feed entries, you can finally set reminders, colors, and other options that Google’s default holiday calendars don’t support.

It also handles yearly refresh automatically, so the holidays get updated without needing to re-import anything.

If anyone wants the script or wants to see how it works, feel free to DM me.