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.

25392 Topics

K
Kalps.bBeginner
asked in How Do I

Using Google Distance Matrix API in Zapier - possibly from within a Jotform?

Hi I currently have a JotForm that contains 2 postcode columns.  I want to be able to calculate the distance and travel time between these 2 columns (postcodes) if possible please.Would it then be able to populate 2 new columns in the JotForm with the returned values from Google Distance Matrix API?What would you recommend please?  

6
Troy Tessalone
10 months ago
P
pcsandersBeginner
asked in How Do I

Pulling historical or existing data

Hello, I am fairly new to using Zapier and I am trying to find a way to pull existing or historical data from Basecamp to add to Hubspot or Google Sheets.  Example, my organization uses Basecamp to communicate project requests, tech issues, or information that needs to be shared to various teams.  I am going through Basecamp and adding a comment on each message that I would like to add to a knowledgebase or create a support ticket for.  I am using #knowledgebase to these comments to pull these posts, which could have been created last month, last week, or even earlier than that.  When I try to create a Zap, it seems like it won’t work unless there is a new item created, etc.  However, I may just not know use Zapier to pull information that already exists.   The logic would look something like:Find any Basecamp message board items in a project area with comments with #knowledgebase and create a new ticket in HubSpot or create a new row (with that content) in Google Sheets.Thanks

6
P
1 year ago
T
trackingpremiumNew
asked in Troubleshooting

Quickbooks Online Business Validation Error: The payments you entered add up to more than the amount received

HI,I try to created a payment to an invoice with stripe and quickbooks and I get this error message when I run a test. Failed to create a create payment in QuickBooks OnlineBusiness Validation Error: The payments you entered add up to more than the amount received. Everything looks good from my end. I wonder if there is a way to resolve. Thank you

2
Danvers
1 year ago
Weekend
WeekendBeginner
asked in How Do I

How can I add attendees to an event in Google Calendar without removing prior ones?

I am trying to add attendees to an existing event in google calendar (from wp forms) but get an messge saying "all existing attendess will be replaced...." How can I ADD attendees to an event without removing prior ones??

6
ken.a
4 months ago
RashidatO
RashidatOBeginner
asked in How Do I

How to automatically upload Zoom recordings to Mighty Networks

Ok so I know there is a way to upload a file to Google Drive.  I’m trying to do something similar in Mighty Networks.So, if I were to do this manually the steps would be:Download the video file from Zoom. Start a Quick Post in Mighty. Upload the video, add the text, and format the post.I currently have a zap set up to do the Quick Post in Mighty, but seemingly can only post the link rather than uploading the video.  Any suggestions on how to fix that?

5
SamB
Community Manager
9 months ago
zapheria
zapheriaBeginner
asked in Troubleshooting

Your path would not have continued... help please

 I have created a zap that and followed exactly what someone else has done in my Circle community - but for some reason it doesnt work for me  The goal is to have a leaderboard in Airtable for comments by members in Circle As you can see from the first screen shot the flow and path I am hitting the problem in the path for user does not exist (2nd screen shot)- even though its almost identical to the path for user does exist (3rd screen shot) which is working fine I am pretty new to Zapier and really trying to find my way around so would be grateful for any help - thank you   

5
ken.a
11 months ago
INH
INH
asked in Code & Webhooks

Include image attachment in Mastodon Status using Webhooks

By following https://blog.fosketts.net/2022/11/13/how-to-auto-post-to-mastodon-using-zapier/ and the official Mastodon API documentation I’ve been able to setup a Zapier automation using Webhooks by Zapier to post a Status (a title + URL) to a Mastodon instance.Also I’ve been able to upload a media item using the endpoint “/api/v2/media”. And valid ID is returned after this step in Zapier. https://docs.joinmastodon.org/methods/statuses/#createhttps://docs.joinmastodon.org/methods/media/There is an issue with including the image attachment to the Status. According to the blog-post and the API documentation an Attachment ID is to be included as a media_ids[] in Data. But for some reason this doesn't seem to work.There is not error but also no image is included.Step Configuration:This works for a regular Status post. But including a valid Attachment ID for media_ids[] doesnt have the desired effect.  I'm using the https://mastodon.social/ instance.  

2
INH
8 months ago
woodielanderos
woodielanderosNew
asked in Troubleshooting

Creating Airtable Invoice (Supporting Line Items) with Google Docs

Problem: I am having a problem with inserting a table of line items from an Airtable invoice. I am looking for some form of format to not have to use Google Sheets. I try everything and was unable to separate each item into a separate row. I tried formater to use the comma to line break but then the dollar format ($1,000) got all chaotic. It would essentially use the comma in the $1,000 to break it in half and separate it down.Goal: Add Airtable Line Items to Google Docs Invoice that is automated from Zapier.Note: I don't want to use Documint, Quickbooks, Google Sheets, or even Page Designer.

9
Troy Tessalone
1 year ago
M
Mess to BlessedBeginner
asked in How Do I

Eventbrite & google calendar integration

I want my event on Eventbrite to show up on the Public Google Events Calendar. So I did an Eventbrite & Google Calendar integration. I did it once correctly. It took a while for me to get the “success” email but it worked. It showed up on Google Events.I want to do a repeated event, every Saturday and I think I filled out all the questions correctly. BUT my event isn’t showing up for the next Saturday event. So I created a new event and published it but I’m not sure if I did it correctly.How long does it take to get a “Success” Your transfer is complete”?How do I know I have a transfer in the works? (Not sure if I did it correctly)Thank you for your time.

15
SamB
Community Manager
1 year ago
amplicity
amplicityNew
asked in Code & Webhooks

Update row in postgres with JSONB data

We have a postgres table with a JSONB column we’d like to update. We’re using ‘Update row in PostgreSQL”, however, when we specify a value, such as:`{“key”: “Value”}` ..it inputs it into our db with escape characters that render the JSON invalid. We have also tried single quotes and other formatting, but are unable to find a consistent format that works.  How can we format a jsonb value?

7
amplicity
7 months ago
C
cryptorunrBeginner
asked in Troubleshooting

GPT error "It appears that the required Zapier AI Action, "XXX," is not currently available in your Zapier account.

I am having issues with my custom GPT saying I have no AI Actions available when I do. I have one AI Action that worked a couple of times and now I keep getting a GPT error saying there are no actions available.Error message  My AI Action  I used the Zapier AI Actions: Live Demo to test my AI Action and it succeeded. So I know my AI Action is configured correctly.  Not sure what’s going on and looking for guidance.

7
SamB
Community Manager
2 months ago
R
RobRobBeginner
asked in Troubleshooting

Mailjet Template Email Send - [TEST] in Subject Line

Hello everyone, I added an action within one of my ZAPs for sending a transactional email via Mailjet. I have configured the fields provided and everything seems to work correctly with only one problem: the subject line of the received email always has a [TEST] at the beginning. The template is correctly published to Mailjet and I couldn't find any options around to help me solve the problem.Does anyone have any ideas why and what I'm doing wrong?Thank you. 

2
R
1 year ago
R
Ric StarostBeginner
asked in How Do I

Not able to add Paths to a Zap

Any idea what would cause “paths” to not show up as an option when trying. to nested paths. It says “Paths must be on the last step”. Well it is the last step and I am not getting that option. I got it on another zap, but cannot duplicated on a new zap? 

7
Troy Tessalone
1 year ago
Z
zapmember29192Beginner
asked in How Do I

How do I make Zapier get Notion database properties?

I want to automate a process that involves three steps.The first step is to set up a schedule that runs every day at a certain time. The second step is to connect to my Notion database and fetch all the information from it. The third step is to send a message to a Discord channel using a bot. The message should look like this: "Task name" is due on "Due date". "Assignee", please complete your task. How do I do that? I am stuck on the second step. I select "Find Database Item" in the Notion step, but then it asks me to enter values for my properties, which is the exact opposite of what I need, which is retrieving the data from my Notion database that I can select the properties in the Discord action. Thanks!

9
Troy Tessalone
2 months ago
L
leoqiuNew
asked in How Do I

Split text by comma and add to google sheet

The data looks like following:Name: Leo, DylanAge: 20, 21Country: Canada, France I would like to split them by comma and add two rows into google sheet:Leo 20 CanadaDylan 21 FranceIt should also work when I have n set data separated by comma and add n rows to google sheet. How should I make it happen? Thanks.

2
andywingrave
3 years ago
N
NowCertsBeginner
asked in How Do I

Static sample includes fields not found in latest task history (NowCerts)

Hy-We are trying to publish our zaps.When we are try to validate our zaps, we are receiving almost same error against each trigger. But what suprising is that, if we create zap against them they are working fine.e.g .If i said that on creation on new prospect in our application , will create  new contact in google contacts. Its work perfect, but validation is not working.Here is the error sample. Static sample includes fields not found in latest task history(ID: 00372a99-04fe-aff4-9d6e-cc09f3f15610); extra keys: "address_Line_2", "address_line_1", "agentsModel", "appliedTags", "business_type", "city", "co_insured_date_of_birth", "co_insured_first_name", "co_insured_last_name", "co_insured_middle_name", "csRsModel", "customer_id", "date_of_birth", "email", "first_name", "last_name", "middle_name", "referralSourceCompanyName", "refferal_source", "sms_phone", "tag_description", "tag_name", "website", "year_business_started", "zip_code" Trigger is New Prospect: Sample Data: {  "database_id

5
nicksimard
3 years ago
L
lmazzolaBeginner
asked in How Do I

News feeds posted to facebook group

Hello,Can someone point me in the right direction? I would like a zap that would search google news for a key word and when it finds articles on that key word to then post the article to a facebook group page. I see a zap for facebook groups and can handle that part. The problem is what zap can search for articles with a key word ? thanks

1
PaulKortman
4 years ago
H
HermesBeginner
asked in How Do I

Clickmeeting - integration issue

Hello, I’m trying to integrate Clickmeeting via Zapier with Wix. Although Zapier sees the Clickmeeting (after adding API), however it doesn’t see the any of the meeting rooms.  Have you encounter such issue ? How to solve it? Thank you in advance for your help. Regards,  

6
Liz_Roberts
4 years ago
M
MomstirNew
asked in How Do I

Ship Station Store Sync

On the Zapier setup with ShipStation it looks like it only will import orders.  I want to create a zap to simply trigger the “store sync” because I have automation in ShipStation setup but the store sync is not triggering at ShipStation.   Ala - Email comes in with order, zap goes to Shipstation requests store sync.    How do I set this up?

1
Danvers
3 years ago
P
pfriend33Beginner
asked in How Do I

Date Format From Gmail Gets Day/Year Wrong

I’m trying to extract the year from date component of a Gmail message. In the attached screenshot, the date pulled from Gmail is Jan 12, 2020.Zapier is seeing this as Jan 6, 2022 though. I checked the drop down for the “From Format”, but all the options are some variation of Jan 6, 2022.Any ideas how I can do this? All I want to do is extract the year from the Gmail date and then use that year in the next step of my Zap.Thanks! 

3
P
3 years ago
T
TimeZestBeginner
asked in How Do I

Identity and Icon in post to Microsoft Teams

Hello,We are migrating from Slack to Microsoft Teams. I do clearly see that there are far more options to customize posts to Slack. I’d love all those options, but the main issue I have is simply the identity. When I set up a Zap it posts to Microsoft Teams as me. My name, my photo, my identity. If I am doing a post from a 3rd party app I’d prefer to make it look like the post is from that app (name and icon) or at the very least make it appear that it is a zap/automation instead of appearing as a personal post from me. Thoughts? How can I do this?Thank you!

2
T
3 years ago
Brandi
BrandiBeginner
asked in How Do I

Automatic Charging in Stripe?

Hey, all! I have a Squarespace account with Scheduling built in, allowing me to set my available hours and clients to book sessions with me on their own. Part of my process is that I charge half of the total fee of my services up front to book a call and then charge the second half after calls are complete. The first half is automatically charged, but Squarespace doesn’t have a feature where it follows up to charge the final half of the fee once an event/session is over. SO—What I want to do is set up a Zap that looks something like: Trigger app: Google Calendar When this happens: Event Ends Search term: “Hour” (all of my paid sessions have the word “Hour” in them) Then do this: App: Stripe Charge customer associated with call for second half of fee One problem I see here is that, for whatever reason, Google Calendar doesn’t pull in the email address/name/anything associated with the person who booked the call through Squarespace. I thought I might be able to use that data + ma

2
Brandi
3 years ago
R
ryannelsonNew
asked in How Do I

Having Issue between Emma and Google Sheets Integration

Trying to set up a simple connection between Emma and Google Sheets, but keep running into the following errors… My goal is to create a flow from Emma to Google Sheets when a New Subscriber signs up or/and when an Existing Member is Updated. I have done a setup like this with Active Campaign, and it literally takes a couple minutes with zero issues. I have been working on this for a couple hours. I am getting a ton of error messages like the ones below, along with 504 Error Messages. Would appreciate any insight or help anyone can give.    

2
nicksimard
3 years ago
T
TommyismynameBeginner
asked in How Do I

Want to import Google Analytics traffic into AirTable

Trying to see if this is possible.  In Airtable, I track a number of URLS of the content we’ve published. Ideally, I want to have Zapier look at the URL in AirTable, match it up with Google Analytics, find the metric I’m going after (in this case let’s say unique pageviews) then push that number back into AirTable in a cell near the URL.  Has anyone done this yet? 

4
Liz_Roberts
3 years ago
D
DigtalPymeBeginner
asked in How Do I

Adalo&MYSQL zapier not working (Adalo record Update)

Hi, Im trying to connect a MYSQL database and update an Adalo table record when a MYSQL table record is updated.i create the zap but in the second step, Adalo part, the configurations asks for a “Record ID” not defined in the Adalo back end.  The field is mandatory: If you enter the Adalo’s table ID, the test respond with an error:Is it not possible to use this integration?Regards,Antonio

6
D
3 years ago
Terms & Conditions