Google Sheet /Excel Sheet sync in ERPNext

ERPNext
1

Are there any custom apps that support realtime sync of google sheets or excel sheets to erpnext?

2

I’d be very interested in understanding the work involved in connecting ERPNext with Google Sheets / Excel Sheets.

3

you can checkout SHEETS app in frappe marketplace

4

I’ve looked around for something similar, and there are a few options that can sync Google Sheets or Excel with ERPNext in real-time, though they often involve some manual setup with APIs. I ended up creating a simple integration myself using Google Apps Script for Sheets.

1 Like
5

I ended up creating a simple integration myself using Google Apps Script for Sheets. It’s not perfect, but it gets the job done. Taking a few Excel courses at www.myexcelonline.com helped me understand formulas and macros a lot better, which came in handy when I was trying to automate things like this.

6

Would you mind sharing your script with the class? :pray:

1 Like