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
+14
Hi
is this what you’re trying to do?
Oh Thanks, Dear Troy
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
+14
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
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?
+14
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
+14
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,
+14
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
+14
Either of these data points from Step 2 will work when mapped dynamically as the Row value for Step 3.
or
+14
FYI: You’ll need to manually test each step of the Zap again to have it update a different row.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
