Find answers to your questions. Ask the Community for help or hire someone to help you.
#REF Connect 2 Google Sheets with each other possible through Zapier
Hi, I have the following Zap User subscribes to email list Trigger: Copy Google Spreadsheet 1 Trigger: Copy Google Spreadsheet 2These Google Sheets are communicating with each other through =IMPORTRANGE, which is fine, but as soon as a copy is made, the files require to be given access again to communicate with eachother. Since we want this all to be automatic we are wondering if this above part is also possible with Zapier. Sheet 1 is the Sheet which is shared with the new email list subscriber.Sheet 2 is the “backend”. Here are all the secret formula’s, which help the user get to a certain answer on Sheet1 without revealing the formulas.
GET data from multiple URL in the same Zap
Hello, I’m trying to create an automation with Zapier to check if a product is out of stock on Amazon. Here is my current automation:Step 1: Every day in schedule by Zapier (scheduled 1 time per week)Step 2: Get Many Spreadsheet Rows - I linked a Google Sheet file with 10 lines of URLsStep 3: GET in Webhooks by Zapier - here is where I get stuck because I don't know how to get Zapier to check multiple URLs in only one ZapStep 4: Only continue if… Text contain a specific css class (out of stock class)Step 5: Send Outbound Email in Email by ZapierDo you think I'm doing it right/is it possible?Thank you in advance for your help!
Creating Google Calendar Event from Trello Card Start/Dur Dates
Hello! It seems pretty straight forward however I only have the ability to trigger from Trello using a set amount of time before a card is due… is there a way to create a trigger off the fact that a due date is added? If so is there a way to check that there is also a start date on the card to ensure the accurate data is there to create the event?Ultimately I want to use this to schedule tasks in Trello that populate out to technicians as events. I can get it to work beautifully when testing but the trigger itself doesn’t execute properly (instantly when dates added). Thanks!
Calendar To Todoist question
Hello Zapier Community,I’m trying to solve a problem. I’d like Zapier to read a calendar event and then add a new task to Todoist. But the created task has to be one year later from the date.todoist event = event date in calendar + 1 yearWould be happy if someone helped,Ales
Picking up from someone else's history: the actual location of a spreadsheet
I am picking up from an associate who no longer works on this task. We have an active Zap which is running well, taking web-received form info, and placing it on a spreadsheet. I can see the Zap works and flows to a spreadsheet. But I don’t know where the Excel spreadsheet lives, or how to access the results. Thoughts on how to deduce this?
Help with Wix and Zoho
Hello, My goal is to connect a New Wix order to a Zoho Sales Order either through Books or Inventory whichever works best. Issues i’ve encountered are that Wix isnt pulling Real Data only pulls sample data. Also it does not have a field for the State so this will need to be a custom field i have tried adding it but i havent been able to. So i have tried using the Automation that wix creates. also i have tried creating a webhook but i dont know how to link the webhook. Anyhelp would be appreicated.
Using Checkboxes in Sheets to trigger Slack Messages
Hello folks, I have a ZAP that I want to trigger when a checkbox is ticked in a column.I currently have it set up to trigger when a column is updated, and all the cells in that column (where there are rows that contain data) have an empty checkbox in them by default. The problem is, it appears never to actually trigger this first step. I do have a filter set up for step 2 as shown here:But the ZAP never gets started. When I tick the checkbox in the spreadsheet, I expect Zapier to understand that as an Updated Row from Sheets. But it is not even starting the first step, so there’s no history to investigate.Why wouldn’t ticking the checkbox in the assigned column result in a trigger?
Jotform - data entries missing
Hi Community,I’m having trouble with a simple Jotform Zap.The data that the user enters into Jotform is not coming through into the Zap fields. Attached is a screen shot of the Jotform and the Zap.Basically I just want the numbers that the user inputs for each flavour to come through. I’m sure this is something obvious that I just can’t figure out!Appreciate anyones help :)
Arive-Hubspot Integration: Finding and Creating Association in Hubspot after a Deal Creation
Hi Zapier Community, I'm trying to integrate Arive and Hubspot. However during the process, I’m having errors in my 3rd and 4th step which is seen in the screen shot below. ( Deal to contact association) I created manually a contact in hubspot using the same email with the test deal that I have. However, after it created a deal in hubspot, it did not find any associations (this should still be a success even if there are no associations found because of this However, when i tested it, the error occurred. Maybe I’m doing something wrong? My 2nd concern is the 4th step. Even if there’s a current contact (that has the same email) It did not create the association automatically. Hopefully you can help me.
Creating a card inside trello with adress field
I am trying to create a zap that creates a card inside of trello after a form submission. I got everything to work however I figured out that inside of the “ trello zapp “ there is no option to target the adress-field inside of trello.I really hope this going to be added in a future update of the integration. We could really use this in our workflow.But for the time being.. Is there anyone who knows a workaround for this?
Unable to update spreadsheet row after lookup
I have attempted to update an already existing zap as I needed to change the spreadsheet owner it looked at. Now I can’t seem to get it to work again and hoping someone can advise. My Zap steps are:Trigger 1 - New form submission in HubspotAction 2 - Lookup Spreadsheet Row in Google Sheets (using email address as identifier)Action 3 - Update Spreadsheet Row in Google Sheets The error is showing in Action 3 only with every other part working ok. The error is:Failed to create a spreadsheet row in Google SheetsThere was an error writing to your Google sheet. Unable to parse range: 'Sheet1'!True:True This is what I have used for the row to know which one to update: Any help would be greatly appreciated.Thanks
Is it possible to add a condition if the payment date is today to avoid taking past payments?
I’m so sorry to send a msg like this but I’m not understanding what´s going on!I developed an app in Glide which record has a checkbox after payment.Once the user pay, the checkbox is marked and I should a message to the recepients. The trigger is exactly this field. Everything was running perfectly in the Automate.io. Here I create a zap like this. In the Automate.io had one for new and other one for update.Once the user marks the checkbox, this record is hidden or it´s not possible to mark twice. Additionaly I save the timestamp of payment. What´s happenning is the this zap is running for some rows that was payed in the past, with no reason!The checkbox field was not updated. Maybe I’m wrong, but it´s look like when a new row is added, the zap run for a random row, I guess!Looking the history, I review a succeeded tasks and the Data in is a payment in the past. Why?Since I have the timestamp of payment, is it possible to add a condition if date of payment is today? a way to avoid ta
Can Zappier access confidential information in programs it's integrated with?
Hi -- I am interested in using Zappier and had a specific question about Zappier’s ability to “pull” data when it’s integrated with certain software. For instance, if I create a Zap between Zendesk and Slack, does Zappier have access to all information stored within each of those program’s accounts, or can it only “touch” information for which it has been permitted to do through designated rules? In other words, if the connected Zendesk account has information stored in Sections A-Z, but Zaps are created to automate certain activity for information contained in exclusively in Sections A and B, is there any way Zappier can extract or access data from Sections C-Z of the Zendesk account?
Bidirectional workflow between Asana and Basecamp 3
Hello! My employer is trying to create a bidirectional workflow between Asana and Basecamp 3. Below is what we’re trying to achieve, and we would appreciate any insights!We have a project management template set up in both Basecamp and Asana. When a new project is created from a template in Asana, we would like a new project to be created from a template in Basecamp. When a task is updated in Asana (new due date, marked complete, etc.), we would like that same task to be updated in the corresponding Basecamp project as well (we would also like the reverse, going from Basecamp to Asana). If several due dates or the entire project's due dates are shifted in Asana, we would like those changes to be made to the corresponding Basecamp project as well (we would also like the reverse, going from Basecamp to Asana)Essentially, we would like the ability to link an Asana project and a Basecamp project together, with most any action in one project being reflected in the other project.
Monday.com integration help
I am trying to create an automation which would use the information in a google sheet (which is populated by my website) to create a new item in my Monday.com board. I successfully did this for one tab of my google sheet but cannot get it to work for the second tab. The error keeps coming back: the app returned "store.monday.automation.error.missing_group". Any advice?
mySQL update values
Hi there - am new to Zapier but so far very impressed.I'm trying to take some numerical values from a Formidable form, add them together and then update a row in a mySQL table with that calculated value.For instance, I have four fields submitted from Formidable (field IDs 50, 53, 52, 51) which will each have a value between 0 and 100.I want to add those value together arithmetically hence the update value in the attachment. Is it possible even for the “update value” field in my Zap to contain arithmetic functions? something like=50+51+52+53 I’ve tried various things but it’s simply treating it as a string which is producing some odd results when the field I’m trying to update is an int field.is this possible to do, or am asking the impossible?Thanks a lot.
Slack workflow error: An error occurred executing a workflow step you own. Check out your workflow for further details.
I’m trying to trigger an email to send within the Slack Workflow builder. I’m using Zapier’s “Send Email with Gmail” feature. The test shows no issues, but when I run the Workflow, it results in this error: “An error occurred executing a workflow step you own. Check out your workflow for further details.”I have replicated the functionality as a standalone Zap created in Zapier and triggered by an emoji reaction within Slack. This works. I have tried Slack’s help, and their response was that they don’t maintain the Workflow steps built by other apps, like Zapier. How can I troubleshoot here?
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.