How to Use Google Forms to Create an Interactive Workflow

Google Forms is the office workflow interface you didn’t know you needed.

Google Forms isn’t just another simple survey tool. In its simplest form, it can be used as a free data collection tool. With a little know-how, you can unleash the combined power within Google Forms, Google Sheets, and Add-ons to create some powerful workflows to help you get more done in the office.

Why Create an Interactive Google Forms Workflow?

Out of the box, Google Forms allows you to collect data and store each response as a row in a spreadsheet. Here we will show you how you can use the same form to work with that collected data to add information to an existing row, or trigger a process.

This is useful in any situation where you need to take action on the data you collect instead of just reporting on it. An example of this is when you use a form to collect a request for a service that requires a response, approval, or some other action. Instead of manually manipulating each new request in the spreadsheet, you can reopen the request in your form to perform the next step in your process.

Read the full article