Find answers to your questions. Ask the Community for help or hire someone to help you.
Trigger Zap when specific value is added in a specific column of your google sheet
Hi Everyone :) Context:I am offering 2 programs to my users. A user who bought program A can purchase program B once he finished his program A. Both program have their own mailing list. What I am trying to doI am trying to update the tag associated to the user in mailchimp based on the program the use purchased. So I’ld like to tell Zap “When the value “Program A” is in column “Program” > Add tag “Program A” in the user profile in mailchimp”. (and the same for Program B) Any thoughts on how I could do that? I’ve found a way to update the tag in mailchimp when a clomun value is updated, but not precisely for a specifc value. Thanks everyone for your help :) Deb
Can I move or copy an action?
Is there a way to move an action fro one location to another if I want to restructure my zap? For example, I want to add a path and move some of the actions into that path. Setting up each action takes a bit of time and needs to be tested. I have a few zaps I want to make this change for.is there some sort of copy/paste operation that can be done with zaps? Is there a way to edit zaps some other way such as getting their raw text representation? p.s. I’m surprised not to find this question already I the forums. It seems like it would be a common need.
Google Sheets use a formula for the supporting lookup column value
So I am using a Zap to find many Google Sheet Spreadsheet Rows. However my Supporting Lookup Column is a number. However I need to select all rows that the number is less then or equal to my value. I have tried formulas with no luck. Thank you.
How to remove field values through automation
Hi there,When Zapier zap sends blank/no-data data to my Webflow CMS fields, if there is an existing field value in Webflow, it is not removed or overwritten with a blank field value as one would hope.As a use case, imagine you have event listings with photos and an address in an database like Airtable. In the first place, you use Zapier to publish the event listing from Airtable to a Webflow item containing 3 photos and an address. Later, you remove one of the photos and the entire address from your original database/airtable.You run the automation (to update the webflow record) with blank/no data fields for one of the photos and the address field, but Webflow won’t remove or overwrite existing field values unless there is a new value to replace them with.I could use Zapier’s formatted step to create default empty space data for fields where data is non-existent, but that would be messy and require me to add one formatter step for every regular field and that would amount to dozens of
Freshdesk empty values
Hi,I have a Zap with Freshdesk updates as a trigger that works fine during the tests but send empty data when is on. I’m sure the fields have data when I created and tested the zap but it doesn’t work.My test:Test Result: In Production:Production result: Can anybody help me to understand what is wrong?Thanks!
Setting up a zap to make a reservation on a specific day of the week (repeating)
My goal with this zap is to book a tennis court reservation. The reservation will be on the same day and time each week. The zap will log in to the account, find the correct date, and make the reservation. The booking app allows the reservation to be made 6 days in advance. For example, a reservation on Thursday, April 29th, 2021 at 8 am could be made on Wednesday, April 21st, 2021 at 8am. I’m using a trigger with the day of the week, Wednesday and time of 8am. The webhook will go to:https://pbtc.skedda.com/booking?viewdate= Then it needs to add the desired date to the end of the URL in this format:2021-04-29 What is the best way to do that? Thanks very much for your help!
Cannot Get URL Shortener to work
Hello, I am new to all this so please bear with me. What I am trying to do seems like it should be simple… Look at Airtable for a long URL, send it to Bitly to shorten, and then update the Airtable record. I have it all setup seemingly ok, except for the step where it is supposed to update the Airtable record… when i set up the action, it asks to select the Record, and then it only works on that ONE record, not all the records in that base that have the long URL. It is driving me INSANE. I then tried to use Zapiers URL shortener, but that one I cannot even get to see the field with the long URL. This is driving me insane and I don’t think it should be so difficult to set up! PLEASE help me!
Add Slack emoji reacji to a specific message after trigger
I’m wanting to create a zap where after a calendly call is scheduled it triggers a search for a specific message in a slack channel using some of the information provided in the calendly scheduled call. Then when it finds that message I want to automatically add a pre-designated emjoi as a reaction to that message.Is this possible?
Renaming an attachment (Gmail to Basecamp)
Hi everyone, I’m new to Zapier and have spent a fair amount of time trying to work this out to no avail. I’m not very technically savvy, so if someone could break this down simply for me, that would be incredibly appreciated.I am converting emails to a new document on Basecamp.I have everything set, except the attachment comes out as a very long string of text: I would like to format the attachment in the clearest way possible, ideally by replacing it with just the original file’s name. I have tried using the formatter, but I’m not entirely sure what tool to use and the changes I have experimented with so far don’t seem to change it - although maybe I am doing this wrong! Thank you,
Amazon S3, move files between buckets/folders
Hello community,We have a 3rd party that will be dropping files into an S3 bucket called “unprocessed”. We will upload those files into another application using Zapier and moving the files onced processed into another S3 bucket called “processed”. What is the best way to move the file from one S3 bucket to another? Do we just end the process with Upload File in Amazon S3 and then a similar delete action?
How to keep formulas from being erased in my Google Sheet in cells where no new data is being added?
Hi,My zap transfers new data from my Wix site to a Google Sheets spreadsheet where a new row is created with data in columns, for example, A:D. So the zap triggers and A2:D2 now have new information.I entered some formulas in my spreadsheet in columns, for example, E:F that depend on the data from A:D. So if a zap triggered and A2:D2 had new information, then the formulas in E2:F2 should change according to the new information. But my formulas in columns E:F are erased. The zap then triggers for A3:D3 and E3:F3 should reflect the new information but they’re also erased and this happens successively for each row.I know that I can fix this my manually entering my formulas in my zaps but it will take a LONG TIME to complete this. Is there a shortcut towards achieving this?
Digistore 24 to Hubspot
Hi Guys,we are currently using Digistore24 as an online payment solution and Hubspot as our Sales CRM. I now want to update our deals in hubspot, whenever a purchase / payback is registered in digistore24. This should be the Zap:Now the problem:Whenever i want to Set up the action the field “object ID” is required to be filled in. But i dont want to change this value, cause its a unique ID already given by hubspot refferring the deal. I only want to update the deal regarding the amount......and the mail. Because i guess thats how the correct deal gets identified in first placeCan someone help me? Thanks in advance :)Mathieu
Use different Google Sheet URLs to retrieve rows from different files
Hi,I’m looking for a solution to execute this workflow in Google Sheets: Step 1In a Worksheet (Google Sheet A) I save a list of different URLs pointing to different Google Sheets (Google sheet 1,2,3,4,5…). I write the URLS in the same column, in different rows. Step2When a new URL of a new Google Sheet is added (URL Google sheet 1, 2,3,4,5…) in the specific column, I trigger the workflow Step3I need to go the that single Google Sheet (since I have the URL of Google sheet 1, 2,3,4,5…), go to a specific Worksheet, retrieve a single row (the only one existing, no problem of lookup) Step4Store the retrieved Row (from Google sheet 1, 2,3,4,5…) to a different Google Sheet B I didn’t find a solution to execute Step3.I have the URL of the google sheet from Step2, I tried to execute a lookup step but if I put the URL of the sheet as Custom Value in Spreadsheet field, Zapier is not resolving the Worksheet name field and the lookup column field. They are all required field to enable the lookup.
How to capture images from Slack messages to Google Sheets?
Hi there, Is there a way to capture images from Slack messages onto Google sheets? We are looking to build a FAQ builder but we first need to compile all the feedback and questions and images onto google sheets . Any way we are able to do that ?
Add new row in Spreadsheet from a daily Google Form
Hi,I’m sending every day new Google Form for daily “working hours” that each employee have to fill and i would like to automatize the questions on a personal and always the same big Google spreadsheet (for each employee). How can i manage it?Thanks!!
Find Spotify Song from URL
Hi everyone, I have a Google Sheet where URLs to Spotify songs are added in regular intervals, for example:https://open.spotify.com/track/4sdhaq0Z4KL5oCF5GCgTtt?si=dd9418fa67474b73 I’d like to add these songs to a Spotify playlist automatically every time a new song is added to the Google Sheet. I’m trying to use the following logic:If a new row is added to a Google Sheets spreadsheet, find the song via the URL and then add the song to a specified Spotify playlist. However, the “Find Song” action for Spotify doesn’t seem to work with URLs. Any ideas for a workaround? Best,Jan-Sebastian
Look for certain text strings in addresses of new Shopify orders to send email alerts
I want to look for certain text in addresses when I receive new orders in Shopify. I have a list of strings to look out for in google sheets, such as "SHS" or "Uni" in it. Then I could get the zap to email me. I know I could use many many filters but it would be a huge amount, because not only would I need a filter for every string, but a filter for every string for multiple address fields, such as company name, street address 1, street address 2. Then it would be useful to search within billing address also. I'm only thinking about maintenance of such a filter because more words would be added later on. If I could just look for these strings in each part of the address it would be easier to maintain. Hope that makes sense.
Facebook Lead Ads Zap not triggering
I am using trigger to import Facebook leads Ads in our sql server database. When I click on “test trigger” it insert a new row in my database but trigger is not working automatically as we got multiple leads but it is not saving in database.And under trigger event I have selected new leads(instant) but still not getting any leads. Kindly help. Thanks.
Run script on Excel
Hi! I would like to run a script on an Excel hosted on a sharepoint. Basically my Excel is fed with new rows based on an RSS feed. I would like to create a ranking on these rows based on the text they contain. However, when I try to create a Zap with a custom code, I can’t get the excel in “input data”. How can I do to do so? Thank you!
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.