Essentially, I want a zap for when a client uploads a video it subtracts one from a number stored on a google sheet, and if that number is 0, instead of sending a message to my editor to edit it in discord, I want it to send a message to the client saying you’ve ran out of edits. The issue I’m having is it’s only letting me do stuff in google drive & not sheets, is this because my trigger is based on google drive? How should I do this? Thanks guys!
Best answer by Troy Tessalone
View original
+14
Hi
You would need to add Zap steps for GSheets.
GSheet Zap triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
Well, I would like the trigger for the spreadsheet being adjusted to be a google drive folder getting uploaded, is this possible?
+14
You may need to configure a different Zap that triggers from changes to a GSheet.
Your Zap trigger is for GDrive when there is a new File in a Folder.
Hey Troy! thank you for responding again.
Sorry if I wasn’t being clear. I need the google sheet to be adjusted AFTER a folder is uploaded into google drive.
To explain, when a client buys 30 edits from me I put the number 30 in a google sheet, the only way to count when a client uses an edit is to track whenever they upload a file to google drive. So I need the trigger to be uploaded a file into google drive, and I need a response to that to be to subtract one from a google sheet.
Is this possible with zapier?
Thanks Again
+14
Did you review the available GSheet Zap actions that you can add as Zap steps?
You would need to add Zap steps for GSheets.
GSheet Zap triggers/actions: https://zapier.com/apps/google-sheets/integrations#triggers-and-actions
Okay perfect man! It’s working for that part thank you so much
But now I can’t seem to get it to replace the 30 with the new number, check it out here:
+14
No screenshot was included.
Apologies here it is
+14
The Row field expects the Row/ID value.
You can map the Row variable or the ID variable from Step 2.
Bro has all the answers, final question.
How do I make a conditional where if a certain criteria isn’t met it does a separate following action? (in my specific example it would be to send a discord message to the client and not the editor)
+14
Paths: https://help.zapier.com/hc/en-us/articles/8496288555917
NOTE: Paths require a Zapier Pro+ plan.
got it bro. thank you tons.
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
