How To Append or Update Rows With Salesforce and Google Sheets

Sync and match data could be a tedious task at times. Especially when you work on multiple projects with lots of variables. Tickets keep piling up, and new information keeps coming, only to make things more complicated. Fortunately, how information is processed and synchronized could be automated with the right tools.

workflows doesn't have to be time-consuming or complex. In today's post we'll show you have to create a quick one, that will make webhook calls and based on those will either perform queries in Salesforce, or append new rows in Google Sheets.

First step would be to login, or create a new account.

From there, click on the Create a Pipeline to open the visual editor where we'll construct our workflow.

Our workflow will be triggered once we get an HTTP callback from another website, for example.

WEBHOOK1

We can specify the type of request (HTTP, JSON), and assign parameters.

Cloudpipes does allow for the implication of regular expressions throughout its pipes. As such, if any were applied, we can check for a particular string of expressions, and for each found regex we'd tell Cloudpipes to store the newly received info in a spreadsheet.

REGEX1

The above shows checking for a particular group of objects based on a specific expression. When found those will lead to Cloudpipes appending new rows in Google Sheets.

GS1

After this step, Cloudpipes will do a query search based on the objects' ID.

SF1

Based on the above query, if objects are found, then Cloudpipes will update the Google Sheets row that we created earlier.

GS2

If our Salesforce query returns no results, then Cloudpipes will make a new HTTP request. If it returns results with values that are true, and matching a predefined regular expression, then Cloudpipes will update our Google Sheets row. A different one will be changed, if our search does not yield the result we're looking for.

EXP1

Using webhooks is a great way to reach out for information available elsewhere. With regular expressions you can pinpoint the exact values that that information holds. And with Cloudpipes you can distribute that data across multiple instances.

Digital transformation shouldn't be scary. Make it your friend with our free tutorial to give your business the boost it needs!