Find answers to your questions. Ask the Community for help or hire someone to help you.
Firebase/Firestore error: Error while retrieving: The specified query does not contain valid JSON. Unexpected token } in JSON at position 122
I need to access the data [timeStamp] but I have not found the way to access that data. If i try to get some data like [category] it is possible. But if i try to get [timeStamp] into [solution] Zapier crashes.This is the structured query that i’m using:This is the error that Zapier shows me:
How do I create a ZAP for: Web Form (Leads) -> Google Sheet -> Agents in Sequence
Hi everyone! I’m fairly new to Zapier and need help in creating a zap process.I have a webform (on a Wix website) from which the leads are going to a Google Sheet (via Wix Automation).I want to distribute these leads among a team of 14 persons sequentially one-after-another.When a new row (a lead) is entered in the Google Sheet (via the web form), I want the lead to be assigned among the team of 14 persons one-by-one as they come in. So when one cycle of 14 is done, it keeps following the process as new leads come in.(Similar to the Round Robin principle of evenly distributing items to everyone in the group. This means that everyone will get a single "lead" before anyone gets a second "lead" and it keeps repeating in a cycle) The leads being sent to the 14 persons needs to be sent via an email separately to each. Email could be from my gmail account.How do I execute this correctly? Thanks in advance!
Zap Discord invitation link from Tweet
Hi There I’m trying to create a zap with the following workflow User tweets Discord Invitation link Selects Discord invitation link from tweet [eg: https://twitter.com/hekim_bey/status/1572158010406961152?s=20&t=GAaTUCQ5vRWvPbtCxQwSJA ] Accepts Invite in Discord Is this possible?
Problem with nordic letters
Hi, i am getting some really wierd formatting on Nordic Letter when extracting text from Gmail and then putting it in Google Sheets. Example: How it should look: Vi bestämde oss för en sittning på tisdag. Lycka till How do i solve this bug?When testing in Zapier it does not look like this.
Importing company/contacts AND deals to HubSpot
I have seen proposed templates for importing company/contacts - both objects at once, but I didn't see anything that has those two AND deals. Does one exist? I am also ready to do my import, and am terrified it will go horribly wrong. Does HubSpot offer hands on support for this process? Other advice/suggestions are welcomed. Could You Please Clarify this One issue.
I put the same input value, but I get a different result (Delay unit operation)
I applied the exact same workflow as other zaps, but the result is different.Date/Time formatter and Delay unit were used. If you test it, the result of Delay Until is One side comes out at +09:00 The other side is -05:00.Because of this difference, I set up a text message at 2 p.m I get a text message at 4 a.m.There are no other variables.How can we solve this?
Automate the renaming of files in Google Drive
Is there a way to automatically re-name files in Google Drive? ie. the original video filename is 2202-28-09-name-1234.mp4 and I have 100 more like that with various file names. I want to name them Video_001, Video_002 and so on. I looked at q+a and in the zap creation and didn’t see this option, but it’s got to be available, right? Thanks in advance!!
Cancelling held runs?
Hi there, I have a free plan and I ran a webinar - more people signed up than my free plan allowed so it is holding about 90 runs until the renewal date.That date is after the webinar though and I don’t want them to run anymore. I’ve turned off the zap, will they still run automatically? Is there anything else I can do to keep them from running? Thanks!
How do I replace multiple string variables with other mutiple string variables? (Renaming the variables as they come)
I have a webhook that is capturing data from our ecommerce store to a google sheets doc. I am trying to replace the name of multiple variables as they come. The problem is that multiple variables can come at the same time creating multiple rows but in the same column. When I use filter, I was only able to replace only one of the 4 variables I need to rename. I tried to run python in code by zapier but can’t quite get the logic to work. Essentially I want to rename the the 4 different variables of input_data with the correct name as it can pushes
Fastest way to create a new spreadsheet that captures all available information?
Many times when I want to create a zap for a new app, the first thing I want to do is capture all available information and record it to a spreadsheet.I am able to see all available information when I connect my app to a Google sheet. (I think so, anyway.)I typically see options like this:id: 48633336name: Agt Gomeydescription:series_id: 1800969location_name: Onlinelocation_id: 48259employee_name: Smiff, Joeemployee_id: 164498service_name: AYCEservice_id: 88046There are frequently dozens of data fields--this one has 74.Is there a way to automatically or quickly make a spreadsheet from that data? Like an option to just give me all the data, and I’ll sort it out later?For now, I am just copying the data field names.(There is a small issue with that--on copy and past, the names and values end up on different lines, like this:id:48633336name:Agt Gomeydescription:series_id:1800969Finally, if I’m trying to save all that data, I have to map each field one by one to the columns.Is there a bett
Static webhook authentication approach
How do I add customer details to Acuity when they register to my audience in Mailchimp?
HelloI want to integrate Mailchimp and Acuity appointments so when a new customer register to my audience in Mail chimp His/ Her details are used as add customer in Acuity appointments so can easily do the appointment scheduling. Thanks
400 error when pulling from a Glide excel page into ConvertKit to start an email sequence
HI Everyone, I am getting an error message 400 when trying to pull from a glide excel page into convert kit to start an email sequence. Essentially I cannot figure out how to pull from the correct column “name” / “email” Any help would be greatly appreciated
How to trigger Zaps on Jira for only certain issues using JQL?
Hello, When I try and create a Zap for Jira I have a ‘Update’ as a trigger option. Is it possible to trigger only for certain types of issues? I don’t see any option to trigger on an update using JQL. I can see a Create option to use JQL. Thank you
How do I create a cue that publishes on a schedule interval?
Hello, I want to create a Zap that includes a queue but am not sure how to word it. Goal: When I see a fb post I like and want to share with my private group, I can trigger a Zap from the iOS share sheet and the posts will only go out once per day (even if I send 5 posts to the group). Support Sought: I could screenshot the photo, then fill out a form and use the caption/file to create a post (no problem). If there is any other intermediate options available, I’m open. How do I build the steps that check if a post has gone out within the last 24 hours, if yes, calculate and wait until it’s been 24 hours, and if no, then send it now. What would I need to do to queue these posts if I come across several I want to share at the same time?
How to select multiple collaborators and tasks on Asana with Zapier
This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.I have connected Zapier with Asana , Created a Zap , New Task in project in Asana to Update Task in Asana . The Reason is we want the people that open us the tickets on Asana , to be added automatically as collaborators in order to have access on the ticket . I have created the Zap and tested it for a single ticket and it works but i can’t find a way to select all tickets or make a rule saying that every ticket that comes in should do that action .
Automatically delete a google calendar meeting when the contact is deleted from Hubspot
Hello there, I’m looking for a workflow that could automatically remove a meeting from my Google Calendar when the contact details are removed from Hubspot. So for example right now we use HS as our CRM and Google Calendar. When someone books a meeting through form → it automatically creates an account in Hubspot and it also books a meeting in my Google Calendar BUT if the domain is not a company domain or the domains we blocked Hubspot automatically deletes the contact details/account within Hubspot but the meeting still stays on my Google Calendar. I hope this is possible with Zapier
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.