How To Search And Update Projects With Basecamp 3 and Google Sheets

Imagine you're working on several projects at the same time and you need to monitor and update them regularly with a timely manner. The incoming information is overwhelming, and you're having a hard time to keep track of every single update.You're racing against the time. It sounds a bit scary. Hold on, do not worry. We know how to simplify project management. With Cloudpipes, you can monitor and update any change happening anywhere across your projects. We make workflow automation easy, while delivering complex integrations across multiple platforms.

Today we're going to explain how to monitor projects, and mark the inactive ones as complete, by using Basecamp 3 and Google Sheet.

Login into your account, or register for our Trial. It only takes a few moments.

Our pipeline starts with Search Rows. What this pipe does is to perform a query in a predefined account, and chose spreadsheet, and check for a particular set of rows based on certain criteria.

GSheet1

Next, Cloudpipes will run a lookup in Basecamp 3 for each Google Sheets row based on their individual IDs.

LookUp1

Here the query is solely based on ID. Then Cloudpipes follows with an IF/THEN condition aiming to check every Basecamp project for their status. If the status is not active, then Cloudpipes will update it as inactive.

IFTHEN1

Once the rows are updated accordingly, our pipeline will proceed to do one final search by ID to mark each project tasks in Google Sheets as complete.

UPDATEROW

The above example is just one way to automate your workflow in order to monitor and update your projects more accurately.

Want to find out how to streamline your projects with Cloudpipes? Book your free workflow design tutorial now!