Google WorkSpace is a work productivity tool that can be used from anywhere in the world. It includes business emails, cloud storage, app integration, and many other features. It is also known as G Suite and Google Apps.
For an electronics manufacturing company we developed a process in place to handle Processed Bill of Entry PDFs received via email. Once the PDFs are received, script extract the relevant data and record it in a Google Spreadsheet. From there, it performs calculations such as duty amounts and taxes. After the processing is completed, it send summary to the finance department to keep them informed.
For a US-based F500 company's Indian division. We created RFQ Automation Scripts using Google Sheets. Script keeps a log of RFQ emails sent to and received from suppliers. The script also consolidates the price list xls attachments in response emails sent by suppliers in a new Google Spreadsheet. Scripts are capable of automatically generating new RFQ log Spreadsheets for new users.
Added support for ACH to existing Google Spreadsheet based Payment Management System. Users can select the payment option as ACH and process data. An ACH CSV file is generated and added to Google Drive. Users can send this CSV file to the bank for further processing. ABA # and Account Numbers are fetched from a custom API developed using Next.js.