Case study

Custom logic to track deadlines in Google Sheets

#googleAppsScript #gmailAPI #gmail #googleSheets #googleSheetsAPI #customAppsScript #digitalTransformation

Project goal

Business processes redesign, interface, dev, implementation, support.

Solution

The project started with a basic need - integrate a third-party webform to Google sheets. As it frequently happens, the scope was altered to consider the connected internal procedures. And then other products.

After implementing the webform, with great teamwork with the client, we re-designed the internal procedures involved in the chain from customer requests to delivering a result for the client.

Digital transformation was prioritized according to expected results and influence to speeding up the current processes. All internal staff and partners were involved as users and beneficiaries of digitalization.

As a result, the average order fulfillment speed increased from 10 days to 4 days. The process became manageable and measurable.