Back to projects
Erply → Google Sheets Sync
Syncs Erply POS data (sales, purchases, inventory) to Google Sheets via SQL pipeline.
Tech Stack
PythonErply APIGoogle Sheets APISQLPandasJupyter Notebook
About this project
Extracts multiple report types from the Erply API — sales by invoice, purchase reports, stock levels, inventory updates — stores them in a local SQL database, and pushes the data to Google Sheets using the Google Sheets API. Includes two sync methods and an ABC/category analysis layer for business intelligence.
Added May 2026