How to Import JSON Payload into Google Sheets

How-To , zenphi Use Cases, , , ,

When requesting data from APIs and other internet-based apps, it is given in the form of a Json payload. That payload will be in its static form containing the headers and the rest of the information you’ve requested. Whether you have encountered Json payload in the past or going to in the future, looking at …

Read more

Automating Your Incident Report Workflow on Google Workspace

How-To , HR Use Cases , Legal Use Cases , zenphi Use Cases, , , ,

Automating incident report workflow on G Suite can bring you a lot of advantages. Incidents happen in and around the workplace. And when they do, it is bound to interrupt some parts of your business operation. Incidents also may or may not incur injury or loss and/or damage to company property. The former may lead …

Read more

How to Use the Google Sheets Lookup Row(s) Action

General , How-To , zenphi Use Cases, , , ,

When automating our workflows on Google Workspace, we heavily rely on Google Sheets to store data and also to lookup reference data. Say you want to look up customer information by customer id. We usually store customer information in a sheet and will need to scan through the Id column to find a match. The …

Read more

Dynamically Generate Google Slide Using Google Sheets Data and Export it to PDF

How-To , zenphi Use Cases, , , ,

Automatically turning a set of data from one file to another can save you and your team untold amounts of time, not to mention how it will innovate and speed up several areas of your daily automation operations. Data entry is such a huge part of every business. That is why it is no surprise …

Read more

Google Forms Workflow Automation and Approval Tasks

Approval Workflows , General , How-To , zenphi Use Cases, ,

The world we move in revolves heavily around data. In the modern business world, data is the driving force behind impactful and cutting-edge decisions. Trends and statistics are both closely monitored and analyzed so we can incorporate them seamlessly into business strategies and processes. Given how vital data is to business, experts have poured time …

Read more

Automate Issuing Australian COVID-19 Permitted Worker Permit on G Suite

HR Use Cases , zenphi Use Cases, ,

Resources: Permitted Worker Permit for Full Time Employees(Google Docs) Permitted Worker Permit for Part Time Employees(Google Docs) Employees Schedule (Google Sheets) zenphi Flow For Generating Worker Permits As part of the constant battle against COVID-19, and considering the recent rise of the number confirmed cases in Victoria, Australia, the state government has put in place Stage 4 …

Read more