Skip to main content

Hey Zapier Community, Hope All Is Well

 

I’m Trying To Integrate My Sellfy Store To Zapier

So Far Everything Connected Very Smothly

 

But I Need A Little Help With This Little Zap To Send Out License Serial Numbers To Peeps Who Purchased A Product From My Store.

 

I Know I Need To Create A Zap That Read Sales Informations From:

Sellfy

Then Print A Line To Google Sheet

And Then Gmail Picks One Line Of The Google Sheet And Send It To The End Users Email.

 

But How?

 

Any Help Is Much Appreciated

 

Hi @Natanrezaei 

is this what you’re trying to do?

 

  1. Sellfy New Order with Status
  2. GSheets Add Row
  3. Gmail Send Email

Oh Thanks, Dear Troy @Troy Tessalone 

I Really Appreciate Your Help

 

I’ll Try This, And Come Back In A Few Minutes :)


So Far It Updates The Row, But Skips The Coumn That Includes Some Licens Keys :(

New Sellfy Order To GSheets Add Row

 


@Natanrezaei

FYI: The GSheet Add Row action will always create a new row.

You may have to structure your GSheet differently to achieve the desired results.

Add another column to the GSheet, something like ‘Used’ all with a default value of ‘No’.

 

Steps

  1. Trigger: Sellfy New Order with Status
  2. Action: GSheet Lookup Row (search for No in the new Used column)
  3. Action: GSheets Update Row (make sure to change the Used column value to Yes)
  4. Action: Gmail Send Email

@Troy Tessalone I Got It Now, Makes Sense :)

 

And One Last Questions,

To Make This Trigger Work Only For An Specific Product, I Need To Add A Filter, Which Looks For An Exactly Word In The Purchased Products, And Find That Word, Right?

 

So If The Product Contains That Text, It Will Pass To The Steps You Mentioned ABove, If NOt, It Will Do Nothing 🙂 Am I Correct?

 


@Natanrezaei Yes add a Filter as step 2 in the Zap: https://zapier.com/apps/filter/help


@Troy Tessalone Excellent, Now Updating GSheets Works Smoothly :)

It Checks For A No Value In Activated Column

And Update GSheets, Changes That Activated To Yes, And Add The Entire Information In The Correct Columns :)

 

Thank You Sir


Well, Lookup To Update Works As Expected, But Always Updates The Same Row.

Tried To Change It In Gsheets Update Row, ( I Added That No Row To Lookup )

But I Get Some Troubleshoot Error.

Any Idea?

Thanks

 


@Natanrezaei 

You need to map the Row ID found in Step 2 to Step 3 to make the Zap dynamic.

Check this help article: https://zapier.com/help/create/basics/set-up-your-zap-action


This Is Lookup

It Returns The Correct Value: No

 

And Once I Pass It To Update, I Get Errors, It Forces Me To Use A Fixed Row Number,

 

 


@Natanrezaei 

This needs to be the Row ID from the Step 2.

 


Thank You Sir,

Here Is The List Of Lookups, I Chaned It To Id 2, But It Still Updates The Row’:2 

 

 

 


@Natanrezaei 

Either of these data points from Step 2 will work when mapped dynamically as the Row value for Step 3.

or

 


@Natanrezaei 

FYI: You’ll need to manually test each step of the Zap again to have it update a different row.