Are there any custom apps that support realtime sync of google sheets or excel sheets to erpnext?
I’d be very interested in understanding the work involved in connecting ERPNext with Google Sheets / Excel Sheets.
you can checkout SHEETS app in frappe marketplace
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
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.