Trigger workflow from google sheet select box

Help
, ,
1

I’m looking to do something similar to this video where an air table button was created to trigger a workflow. Trying to find a way to do this in google sheets. Trigger a workflow from an Airtable buttton - YouTube

2

Hi @kyleg3

That’s a great question.

Are you looking for a button to be added to each row so you could process a single row individually? Or are you looking for one button to process an entire worksheet?

If it’s the latter, you can add a link in a cell that just opens a Pipedream workflow.

The former is a bit more difficult, I’m trying to see if it’s possible to add a row’s ID as a query parameter to the link.

3

Hi Pierce, it’s the former. For context, this is the full workflow I’m attempting to build.

  1. Trigger is a new photo added to a specific google Drive folder
  2. When detected, use the Photoshop API to remove the background (can I suggest adding adobe and photoshop to list of services)?
  3. Upload background removed photo to drive folder
  4. Add image URL from Google drive folder to new Google spreadsheet row.

This is going to be a product photo for Shopify, so in the new row, I will manually add the additional product fields I need (name, description, price, etc) and once that is filled in, I check the button or checkbox and it triggers pipedream to send the details to Shopify and creates a new product.

4

Hi @kyleg3

Thanks for the full breakdown, that’s very helpful to follow along with.

Have you tried using a formula as a link in a row?

Perhaps you can do something like:

=CONCAT('https://<your pipedream HTTP endpoint>?row=', ROW())

And use this formula for an entire column, perhaps.

Then in your Pipedream, you can use the row query param with the Google Sheets - Get Row Values action to retrieve that rows data?