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.

25202 Topics

P
PAAVONew
asked in How Do I

Point to Comma in NUMBERS EUR

I created a ZAP with which I import ORDERS from Shopify into Google Spread, the problem now is that the EUR information ends with "." instead of ",2 flow in, how can I optimize that in the ZAP? I've already tried FORMATTER, but I can't get it right.

7
MohSwellam
1 year ago
A
ahibbittsNew
asked in How Do I

Post Image to Stocktwits

Has anyone had any success using Zapier to post images to Stocktwits. I can get the text from Discord to Post but have not been able to get the images to go as well.

1
MohSwellam
1 year ago
D
desenvolvimento TINew
asked in How Do I

Invite user Office365

I need help to build an automation that consists inwhen a add a new user in my Office365 tenant, this user have to be invited in other Office365 tenant. Is it possible?

1
nicksimard
1 year ago
S
SteveJBeginner
asked in Troubleshooting

Dropbox - Find File using Airtable Fields - Failed to find a file in Dropbox

When I use Find File task for Drop Box, it keeps failing to find the file, and gives the errorFailed to find a file in DropboxError from halted execution: Nothing could be found for the search.Okay - So I can see the exact file names in my dropbox.e.g. “Mifsud Pluto-DX-25/1/2023-Report.pdf” And I have Airtable fields that give me contents like: “Mifsud Pluto”, “DX”, and “25/1/2023”So I build the file name search action using these fields and add the “-” or “-Report.pdf” as text in between the spaces as needed.Then as I test this task, I can see what it’s going to start looking for:_zap_search_success_on_missFalsedirectory/Bitrads Reports AUTOMATIONinclude_deletednoinclude_file_contentsyesnameMifsud Pluto-DX-25/1/2023-Report.pdfAnd that matches exactly what the file name is. I even tested to see if Airtable thought both strings were the same.Mifsud Pluto-DX-25/1/2023-Report.pdfBut I still get the zap error saying Zapier failed to find that file. I also have re-connected my Dropbox in my

2
nicksimard
1 year ago
V
VesnaTinkerer
asked in How Do I

Zapping posts to Youtube community section - workaround ?

Hi, everyone,It seems that feature request for YouTube community posts is already for some time listed for Zapier developers, if more people need this and post feature request for it maybe it gets implemented sooner? https://zapier.com/app/get-help this social part of youtube is trending very much and in the near future it will surely gain popularity among other social networks, I believe. So I'm totally missing this functionality in zaps youtube actions.In the meantime, has anyone got a workaround for it? I wish to post from Google Sheets to Youtube community section but am not familiar in using webhooks or if there is any other workaround?

3
nicksimard
1 year ago
J
jimrup05Beginner
asked in How Do I

Search for google folder

Hello guys, I have a question regarding my automation process. I have a collision repair center, we use slack to communicate between our department, and google drive to store pictures and documents.  Each vehicle has a specific folder in google drive with unique ID, as of now, when pictures are sent via slack, I manually send them towards the right folder in google drive. I was wondering if I could create a zap that searches the slack conversation for unique ID, and when found store the pictures into google into the right folder.  Example : 1056 front left bumper bracket broken (jpg picture attached).Once my shop manager sends the message, it will send the jpg into the right folder.   We use slack because we can communicate messages and voice messages to know exactly what the pictures are for, which can’t be done in the google drive app.  Is this doable ? 

1
Troy Tessalone
1 year ago
T
TangoNew
asked in How Do I

How to create a folder with name taken from email body?

Hi,So I need to create zap like:- reading email body and take some value from it (gmail)- create (if doesn’t exist) folder in google drive with name taken from email body value- copy attachment from email to this folder.

3
Troy Tessalone
1 year ago
W
WaggieBeginner
asked in How Do I

Delay sending automaticly emails after adding a row in Google Spreadsheet

Hello!I have a question about uistelling automatic mails. I have a workflow, where the Workflow is started when creating a new row in Google Spreadsheet.It does happen that these rows are added in the night, I don't think it's neat that my customers then receive an email in the night.Therefore, I would like to delay the emails until 7:00 in the morning.So every day after 7:00 in the morning, the trigger may be started. I now use Zapier Delay and then I just fill in a time of 7:00 but this does not work.Does anyone have a solution for me how to arrange this?

9
Jillian
1 year ago
L
lorcurcs86New
asked in How Do I

How do I make SendGrid send an automated email with a unique QR code to users after they purchase a membership card on my site?

Hi everyone.May i connect zapier with sendgrid in order to send automated email to users after they purchased a membership card in my site? And every email had to be sent with a unique Qr code.What are your advices?Many thanks in advance

1
Jillian
1 year ago
D
danlingxNew
asked in Troubleshooting

I get a blank window when trying to link to MailerLite

Hello! I try to link to MailerLite but it keeps showing this. I tested in both Chrome and Safari and it’s doing the same thing. Can anyone help? Thanks a million. 

1
Jillian
1 year ago
E
enpipi_gpBeginner
posted in How Do I

We are waiting for Figma and Zapier to work together!

Waiting for Figma and Zapier to work together. Please VOTE if you agree!

0
E
1 year ago
M
mendicotBeginner
asked in How Do I

How do I bookmark to Twitter?

I want to manually save a bookmark to a specific folder in Chrome, and have that link automatically tweeted to my Twitter account, with no extra steps. How do I do this? I have the Zapier Chrome extension installed, and have my Twitter account connected to Zapier.

1
robschmidt
1 year ago
U
Umair ShaikhNew
asked in Troubleshooting

How do I take an action in Podio when my trigger doesn't give me all required fields?

Im connecting FB ads Leads to the CRM PodioOn Step 2 of connecting to Podio under “Set Up Action” Ive got the customers name, number, email address as required field in my CRM but the rest of the information is not required. However, Zapier has customers name, number, email address + 2 more boxes (home address and number of bedrooms) with required field which shouldn’t be required. I cantt move on to the next step because of this.In the FB lead form I dont ask customers for their property address and number of bedrooms so how will Zapier get that information?  I hope I have explained it well. Thanks

2
U
1 year ago
M
millermillerBeginner
asked in Troubleshooting

Moved Trello Card Creates Google Drive Folder then Attaches Folder to Trello Card

Trigger 1. Find or create a Google Drive folder when card moved to a list in Trello WORKSAction 2. Create a folder in Google Drive WORKSAction 3. Add attachment to a card in Trello DOESN’T WORKHere is a screenshot of Action 3.: When I test the action this is the message I get:So from what I can tell from a similar post the *Card (required) field may need to be filled in with ID rather than the original card name. I have not been able to figure out how to make that work. So I can create a google drive folder with the same name as the card I had in Trello, but I am unable to attach the google drive to that specific card.Thanks for any help!

2
M
1 year ago
J
Jordan555New
asked in Code & Webhooks

How to look up a record in a database?

I want to look up a record in a database and then send that data to a webhook.  Here is the flow.1.  A Zapier webhook will receive a post of just an email address.  2.  The zap needs to look for that record in a database.  The database will contain the email record and additional data like name, address, etc...  I was going to use Googlesheets to keep it simple but there is probably a better solution. I am open to suggestions snce Googlesheets has a max on 5m cells.  The database may exceed that.  If that is the case, could the zap search Googlesheets 1, if email not found go to Googlesheets 2...?3.  Once the zap finds the email and the corresponding data in the database row in the database it should send all the data, email, name, address, phone, etc.. to another webhook.  How can I build a zap for this?What is a better database to use than Googlesheets?

1
Troy Tessalone
1 year ago
Cyn
CynBeginner
asked in How Do I

Post video to specific Discord channel when it goes live in a specific YouTube playlist

There is already a flow that does something like this … BUT it posts the link immediately when it is uploaded instead of when it goes live. I upload videos hours/days in advance, so I don’t want the link to post to Discord until it actually goes live. Is there a workaround in the current flow/zap or is there one already available that I just haven’t found yet?

2
Cyn
1 year ago
michael291
michael291Builder
asked in Code & Webhooks

What is the best way to trigger Zaps from a "main" Zap?

Hello,I have built a very complex Zap with 6 Paths which has a very large number of steps (60).My idea was to either split these zaps into 5 smaller zaps to make them a little less complex, reduce the individual steps per zap and make them easier to edit. So my plan was to split the big Zap into 5 single Zaps and trigger the first main Zap from a new WooCommerce order (Save orders, invoice, customers etc. from WooCommerce to Zoho CRM). And the 4 other Zaps should be triggered from the main Zap with a Webhook or something like that. What would be the best way to trigger the other Zaps from the main Zap? Can I use webhooks (i.e. when the first (main) zap is completed then run a second and/or third Zap)?Thanks for help

2
michael291
1 year ago
J
JeffBBeginner
asked in How Do I

Can I perform any cPanel operations with Zapier?

Can I perform any cPanel operations with Zapier?For example, I’d love to be able to automate these steps:Create a new subdomain. Create a new database. Create a new user. Add the user created in Step 3 with all privileges to the database created in Step 2. FTP a couple of files from a Dropbox folder to the subdomain folder created in Step 1. Can Zapier help with this?

2
J
1 year ago
K
katiemoore011New
asked in How Do I

Creating Email Draft from Gmail Template

Is it possible to automate a draft of an email template I already have created in Gmail?

1
Troy Tessalone
1 year ago
M
MartintNew
asked in How Do I

authentication failed: Got 401 calling GET https://www.exemple.com/wp-json/wc-zapier/v1/ping, triggering auth refresh.

Hi everyone, I receive this error message when i try to make a Zap for Woocommerce. Someone have the solution at this problem? authentication failed: Got 401 calling GET https://www.exemple.com/wp-json/wc-zapier/v1/ping, triggering auth refresh.  

34
R
1 year ago
C
Chewy14Beginner
asked in Troubleshooting

Amazon S3 Error

I am new to working in s3 and zapier. I have successfully connected my s3 account but get the following error when trying to upload a video file to a bucket.Can anyone help?[SSL: CERTIFICATE_VERIFY_FAILED] certificate verify failed: Hostname mismatch, certificate is not valid for 'xxxxxxx.com.s3.amazonaws.com'. (_ssl.c:1129)

1
C
1 year ago
K
KJABeginner
asked in Code & Webhooks

Help with a trigger on nested array string value

I’m trying to setup a custom Zapier app to a CRM system with an existing API, to monitor “Jobs” for a change to a specific status value. But the value I need to poll on for the trigger is in a nested JSON array.The JSON response from the API is as follows:[ { "id": 987654321, "jobNumber": "12345", "projectId": null, "customerId": 4567890, "locationId": 2345678, "jobStatus": "Completed", "completedOn": "2023-01-07T02:08:09.972Z", "businessUnitId": 123, "jobTypeId": 1098765, "priority": "Urgent", "campaignId": 3573028, "summary": "This is a test", "customFields": [ { "typeId": 11111111, "name": "Auto-Sync Status", "value": "Hold Sync" } ], "notificationsEnabled": true, "createdOn": "2023-01-06T21:40:18.547645Z", "createdById": 905124, "modifiedOn": "2023-01-11T01:40:08.5405171Z", "leadCallId": null, "bookingId": null, "soldById": null, "externalData": null }]My custom code in the Zapier app

4
K
1 year ago
D
delphimanNew
asked in How Do I

Having trouble connecting to SQL server

When I try to connect to my on-premise SQL server, I got following errorauthentication failed: Could not connect with zapiercon and provided password. The response we got from the server is included below for debugging purposes. (pyodbc.Error) ('08001', '[08001] [unixODBC][FreeTDS][SQL Server]Unable to connect to data source (0) (SQLDriverConnect)') For sure, I open my firewall because I am able to connect to my SQL server from Google Sheet and SQL Management Studio remotely.

3
C
1 year ago
D
Dantango80New
asked in Troubleshooting

OpenAI partial response

I have integrated Google Forms and OpenAI to create a prompt but the response from Chat GPT keeps cutting off after a few paragraphs. Have i got my set up wrong or is this a common occurrence? 

11
christina.d
1 year ago
H
HugalugaBeginner
asked in How Do I

What are best practices for separating first and last name using Formatter: Split Text?

I’m setting up formatter: split text to separate a full name field into a first and last name field. I am using the Segment Index: All (as Separate Fields). This is my setup:First Name: Item 1Last Name: Item 2I think it will work great when people just enter a first and last name:First Name: StephenLast Name: StrangeMy fear is that people will occasionally enter titles and additional names. Would Dr. Stephen Vincent Strange become:First Name: Dr.Last Name: StephenWould I lose all of the extra data? What is the best practice here? Without some sort of name-parsing AI - I think the best outcome would be letting the extra fields get added to the last name field somehow. What would that look like?or is there an option to pass text with more than 2 segments in a different way? I could have these flagged for manual review into our CRM. And if any of this is possible will it require a lot of extra tasks? The way I have it set up - it should just be one task.Any best practices or tips / tricks

3
H
1 year ago
Terms & Conditions