Workflow Automation for Google Forms and Google Sheets

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

How do you remove the manual and mundane process of updating your spreadsheets? One way of doing that is by using Google Forms to Google Sheets automation. Boost Your Productivity with Forms to Sheets Automation Google Workspace hosts some of the most popular and well-loved digital productivity apps. And Google Forms and Google Sheets are …

Read more

Automating City Council Feedback/Complaint Workflow

How-To , zenphi Use Cases, , , ,

Every organization and establishment faces various challenges, and LGU offices and city councils are no exemption. These challenges were made even worse when COVID-19 hit and put the entire world at a standstill. It made us reconsider how we execute our daily operations. Public offices had to slow down even while work piles up. Local …

Read more

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