About Zapier Community
New to our Community? Get to know more about our space and how to make the most of your time here.

Code of Conduct Community FAQ's Zapier Common Questions What to Expect

Get Started With Zapier
New to Zapier? We have got you covered with our Zapier 101 Resources.

Zapier Essentials

Get Support
Have a question? Let's get you an answer!

How Do I...? Troubleshooting Code & Webhooks Developer Zone

Other Help Resources
Wait, there's more! Check out these Community sourced spaces for additional resources.

Zapier Help Center Hire an Expert

Zapier Products
Learn more about Zapier's new products.

Zapier Tables Zapier Interfaces

Zapier Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Tools Hub

Learning Groups
Excited to meet other builders? Check out our interest areas full of doers, dreamers, and in-betweeners.

User Groups

Other Learning Resources
Some of our favorite additional ways to upskill your Zapier knowledge.

Zapier Learn Zapier Blog Zapier Webinars

Product Updates
Check out what is new and upcoming with Zapier with our regular product updates.

Product Updates

Early Access Program
Want to join Early Access? Learn more here.

Get Help

Find answers to your questions. Ask the Community for help or hire someone to help you.

25323 Topics

O
oliviasuneBeginner
asked in Troubleshooting

Issue with Typeform multiple choice fields not mapping correctly in Salesforce.

Hi Team, I’m using a pretty standard flow to create a lead in Salesforce when a new typeform has been filled out. I am having an issue with multiple choice fields from typeform mapping properly and appearing properly in Zapier to be able to map. Some fields (below) populate with all of the custom questions and answers, but some only come up as pre-filled options in Zapier, but come out in Salesforce selecting all options, not just one selected in the form. Has anyone experienced this or can point me in the right direction :)  Picklist one - multiple choice, more than one option permitted, shows up properly in Salesforce  Picklist two doesn’t show up properly in Zapier, can’t select correct options and shows up as all.  example of pre-filled selected fields in Zap, can only populate apparel as a custom optiononly custom option that shows up is apparel :( not the other categories.  Please help me understand what I am missing <3 Olivia

2
O
7 months ago
M
Mitchell ZezimaBeginner
asked in Code & Webhooks

Zap is running twice (Duplicate trigger)

Hello, I am trying to follow this article:  I am trying to get this to work by following the code step described in the above post, I feel like I have it set up correctly but its still triggering twice. Heres some screenshots of how I have the Zap set up and the Zap runs history. Have I done something wrong? Regards  

28
Troy Tessalone
7 months ago
M
MillenniumNew
asked in How Do I

How can I update a Google Sheet with a CSV from a Microsoft Outlook email?

How could i take a CSV in an outlook email and have it update a google sheet?  

1
Troy Tessalone
7 months ago
A
andreajordanNew
asked in How Do I

How do I trigger Zapier Zap only when the value falls below zero in Google Sheets?

Hi I managed to create a Zap that create a draft email when rows are updated on a oogleSheet file. It works pretty fine. I wuld like to tune it a little bit.Actually I want the email to be created only when value of  cell D2 falls below zero. In the google Sheet i put a formula that says … IF( D2 is greater than 0, False, “D2”) In this way zap doesen’t gets triggered at every change of data but if the value of D2 falls  below 0 ZAP gerts triggered, but it happens also when D2 raise again from zero. (i.e friend top up their credit of a car we are using toghether)Can you suggest a way so that  zap is triggered only when value falls below zero?I cannot think of anything.Thanks

5
A
7 months ago
D
Dan WilsonNew
asked in How Do I

Creating Google Drive Folders from Form and Upload to new Folder

Hi I need some help creating a Zap for my client onboarding process. What I would like to do is the following:1. Trigger - Google Forms SubmissionCreate New folder based on this submission Upload files submitted in the original Google Form to the newly created folder any help on this would be great  Thanks Dan

8
Troy Tessalone
7 months ago
A
amiiboNew
asked in Troubleshooting

Twitter error: Token request failed with code 401, response was "errors. code":32,"

Hello, it is no longer possible to link zapier to twitter? My zaps no longer work, yet I see among competitors that you can use Twitter with the developer section. thanks for your help Token request failed with code 401, response was '{"errors":[{"code":32,"message":"Could not authenticate you."}]}'. Nicolas 

2
A
7 months ago
P
PzoneliverpoolNew
asked in Troubleshooting

Google Calendar entry from Zoho Books showing incorrect end date.

Hi. I have created a Google calendar entry from a Zoho books form I only want this as a one day, all day event so I use the event date from my form for both start date and end date in the Calendar action but for some reason it changes the end date to a day before the start dateI can't use formatter to fix this as I'm on a free account Thanks 

3
Troy Tessalone
7 months ago
B
Ben TNHANew
asked in How Do I

How do I integrate the Street estate agent website with Zapier for personalized emails and WhatsApp texts?

Hi Guys, I’m an Estate agent in the Lincolnshire area and i am looking to uprgrade our system to allow us to send more persional emails from our system “Street”, which is a specialized estate agent website, using features that Zapier has like the Automated Whatsapp Texts and emails. Has anyone got any experience with street and zapier intergration

3
Troy Tessalone
7 months ago
S
sun-arcBeginner
asked in Troubleshooting

Getting "invalid_request_error" when sending Dropbox file to OpenAI

Hi!I am trying to send an mp4 file from Dropbox to OpenAI for getting its transcription (this Zap -- https://zapier.com/apps/dropbox/integrations/dropbox/1252350/create-transcripts-of-audio-files-with-openais-whisper) and I get “Failed to create a transcription in OpenAI (GPT-3, DALL-E, Whisper) The app returned "invalid_request_error".” I’ve tried all possible options in Action -> File field, but it does not work. I also tried to use another file, or even Google drive instead of Dropbox the result is the same: "invalid_request_error". I attach the screenshots, hope it will help to detect the problem.       

9
Troy Tessalone
7 months ago
C
ChaterjeenNew
asked in How Do I

How do I integrate Darwinbox HRMS with SysAid?

How Do I integrate Darwin box, HRMS application with SysAid? Is there any case study available or anyone tried that?

1
Troy Tessalone
7 months ago
A
Andrei_MNew
asked in How Do I

How do I embed a Google Sheet link as a hyperlink in a Gmail email?

Hello! I created a trigger in google sheet to send an email via Gmail. In generated email, I want to attach a link embedded in Google sheet cell as a hyperlink, however, I cannot figure out how to do that. I tried HTML code but it simply sends the name of the excel sheet. I want it to look basically like this , where the hyperlink refers to a google sheet file that lives in a cell. Any solution to this? Thank you!

1
Troy Tessalone
7 months ago
Hispanic008
Hispanic008Beginner
asked in Troubleshooting

Twitter error: We hit an error adding your new account. Token request failed with code 401

When I try to connect the twitter account to zapier it gives me an error message.attached image:  

3
Troy Tessalone
7 months ago
T
TFeghaliNew
asked in How Do I

Can I request a refund for the unused plan after downgrading our account?

Hello,We started a refund process for 3 months of unused plan, because we dowgraded it to a free plan but it didn’t work and still charged us. We started the procedure of refund in billing section in our account but we didn’t receive anything. I read we have to contact the support to get the refund back. Help please. 

1
ken.a
7 months ago
KBradford
KBradfordBeginner
asked in Troubleshooting

Failure to move file from previous step in Google Drive

I have a zap that imports a CSV file from Google Drive, loops through the csv file and inserts rows into Smartsheet. I have tried to add a step to move the file to an archive folder in Google Drive. When I try to test the step I get the error: Failed to create a move file in Google Drive'NoneType' object has no attribute 'get' The file is specified as 1.File: (exists but not shown) from the initial step New File in Google Drive. The Zap I am working on is “Import Staff Data From Workday” Any ideas would be appreciated, I have tried everything that I can think of… Thanks!  

5
ken.a
7 months ago
I.Raz
I.RazBeginner
asked in Troubleshooting

SQL Server error: Error during execution: (pyodbc.ProgrammingError) ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'id

Hello,I am trying to proof a customer that Zapier can help in connecting SQL Server to other systems. When creating a new transfer, I am asked to enter a query which is not working. The source of the data in an SQL view which does not have a column named 'id’, instead the unique identifier called 'key'.It seems the query is expecting to get a column named íd’, the error details can be found below. How can I query tables without a column named íd'? Error during execution: (pyodbc.ProgrammingError) ('42S22', "[42S22] [FreeTDS][SQL Server]Invalid column name 'id'. (207) (SQLExecDirectW)") [SQL: SELECT TOP (100) "Customer Number" FROM ****.dbo.**** ORDER BY "Customer Number", ****.dbo.****.id ASC] (Background on this error at: https://sqlalche.me/e/14/f405) 

4
J
7 months ago
M
MarcDanielBeginner
asked in How Do I

Offer segmentation based on what people choose in Facebook Lead Form

Hi everyone! I’m thinking of sending a custom offer based on what my leads choose when they fill out the Facebook Lead Ad Form.So if they choose that they are a company, they will get a different offer than if they are not. Can you help?I couldn’t find any option in the Zap that let’s me do this based on the answers chosen in Facebook Lead Forms. Thank you!

3
ken.a
7 months ago
A
aim277New
asked in How Do I

Delete Row in MySQL

I am connecting bitrix24 with MySQL for deals management, how can I delete data row in my MySQL when the delete event is triggered from bitrix24? because previously I only found events for create and search in mysql events

1
ken.a
7 months ago
S
ShazedNew
asked in Troubleshooting

Facing validation error when creating a Zap for different tax rates between Shopify and Xero.

I’m trying to set up a Zap that creates a new invoice in Xero when an order is placed in Shopify. Our products have different tax rates - 95% are GST on Income and the remainder are GST Free Income. I’ve tried every tax preset from Shopify and they all cause a validation error. The specific wording of the input field in Xero is GST on Income or GST Free Income.Can anyone help problem solve this?

2
S
7 months ago
Blast Recording
Blast RecordingBeginner
asked in Troubleshooting

There was an error writing to your Google Sheets: Unable to parse range: 'Breakdown"!2023-05-09:2023-05-09

Hi,  I’ve been trying to get a Zap to work in which I:  Register an invoice has been created in Square Lookup the the spreadsheet row in Google Sheets (in this case, the date due) Fill out necessary data.I have tested the zap and cannot get past the last stage as I keep getting the error:  Failed to create a spreadsheet row in Google SheetsThere was an error writing to your Google sheet. Unable to parse range: 'Breakdown'!2023-05-09:2023-05-09 I’ve tried numerous solutions but nothing seems to be working. Any help would be appreciated!  

10
Z
7 months ago
F
flori123Beginner
asked in How Do I

Duplicate Zap

This article suggests to click on the three dots to duplicate a zap https://help.zapier.com/hc/en-us/articles/15408145778829-Duplicate-your-Zap But I can not see them when looking at the Zaps overview in my folder https://zapier.com/app/zaps/folder/  

3
ken.a
7 months ago
G
genieNew
asked in How Do I

Is Spreadsheet trigger and Sending Gmail one task for one mail?

I need some help to choose which Zapier plan to do. What I’m trying to make is mail merging zap.Auto response mail would be sent when there is a new row in specific spreadsheet. and after several tests, I wonder how to count zap tasks about my process.Is Spreadsheet trigger and Sending Gmail one task for one mail?If it’s right, with the Zapier plan the number of emails that can be sent is too limited for me,,Plz leave some advise..!

1
Troy Tessalone
7 months ago
F
flori123Beginner
asked in How Do I

How do I prevent multiple Google Calendar entries when updating Notion "follow-up" date field?

I have a simple notion customer database in with a “follow up” date field. It triggers a google calendar entry.The problem is that the google event is created everytime I update the customer (for example if I change a contact). So I end up with multiple calendar entries for the same day.How can I only have it triggered when I change the “follow-up” date field in Notion?I imagine it has something todo with the zapier-filter item, but I tried alot and cannot figure out the correct setup.Any help is appraciated

9
ken.a
7 months ago
RobertN2186
RobertN2186Beginner
asked in How Do I

How do I automate the creation of recurring events after form submission?

Hi all, I want to create some recurring events from a calendar submission. ObjectiveWhen someone submits a form on my site, I want to take the day/time that the form was submitted and create recurring events from the Monday following the form submission.  Current StatusI used some date formatters and a lookup table to take the form submission date and create an event on the Monday following the form submission. I have been able to create a subsequent event using additional date formatters based on the original event. Where I need helpCurrently I am trying to automate the process of creating more subsequent events. I would like to just be able to create some kind of loop and specify the number of times to repeat in order to create 1 years worth of recurring events. For context, the recurrence will be weekly, biweekly, and monthly; I’m hoping that I can use the same solution for all and provide a different date formatter and number of loops for each case.  ToolsWebflow: Form submissionsA

3
Troy Tessalone
7 months ago
tlchris
tlchrisNew
asked in Troubleshooting

Facebook Pages - page not selectable despite working connection

Dear Zapier community, I have a professional FB account linked to my Zapier account. This FB account owns two FB pages. Since yesterday, posting on the page in question has stopped working. As a result, I deleted the Zap and tried to recreate it. However, whenever I try to select the proper FB page while creating a new Zap, only the other page (the one I don’t want to select) shows up as available for selection. The other one is not selectable at all. Has anybody else experienced this issue? It is causing severe disruptions to my flow of content. Many thanks in advance

4
A
7 months ago
B
BillyMBeginner
asked in Troubleshooting

Recording new Stripe Invoice in google sheets

Hi there, I am new to Zapier and am working on creating a google sheet database for all of the Stripe Invoices I’ve sent out. I have a Zap in place that creates a new row in a spreadsheet ever time a new invoice is created in Stripe.  The trouble I am having is that my zap is pulling in a draft of the invoice to google sheets before I’ve inputted the amount we are charging and sent it to our customer. The record then shows an amount of zero instead of what is actually be charged to the customer. I believe this may have something to do with the Trigger being instantaneous but am unsure. Any help would be appreciate! 

6
B
7 months ago
Terms & Conditions