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.

25354 Topics

D
davbrossBeginner
asked in Code & Webhooks

Webhook automation with Google Sheets

I need to send up to 2,000 unpaid (OPEN) invoices to clients and I do NOT want to log into the invoice software to click 2,000 buttons.So, I have javascript that will create an excel spreadsheet of all invoices (OPEN, PAID and VOID).  I take this excel spreadsheet and copy/paste to a Google Sheet.I have set up a Zap that is triggered when a “New or Updated Spreadsheet Row” is created.  This is the Trigger or Step 1 of the zap.  In this spreadsheet is the invoiceID. the invoiceID is used in the invoiceURL that will be used to re-send the invoice.Step 2 of the Zap is to Post a webhook that will fire off the invoice.  I can get it to work one time, BUT ONLY if i have the action URL hardcoded.  As soon as I add the individual InvoiceID into the URL, I get an error on the zap. Does anyone know how to get this to work, if I update 2,000 rows on the spreadsheet at one time?  Is it possible for the POST in Webhooks to send 2,000 times?  I do not see why this wouldn’t work.

2
D
2 months ago
tslyons
tslyonsBeginner
asked in How Do I

How do I maintain mapping order in Zapier when adding a new column to a Google Sheets Zap?

After mapping a set of (say 10) columns to a Zap that adds a row to a Google Sheets workbook, I find I need to insert a previously omitted column so I can join order and payment information by Order-id.  Do I have to re-map all the fields, as it seems the proper mapping is not retained?  Or am I missing something in terms of turning the Zap off and on when modifying the columns to get the presentation order I desire?  Thank you.

2
tslyons
2 months ago
L
lulubugNew
asked in Troubleshooting

Woocommerce products not created correctly via Fast Field Forms

We add new products and update existing products (pricing etc) on Woocommerce with Fast Field Forms. Recently though, when creating new products, pricing, categories and images are all pulling through wrong. They are also getting published when they should be drafts. All fields/details on FFF are correct just not on Woocommerce. I have no idea if this could be because of a Wordpress/Woocommerce update or something else. Any help would be appreciated

2
ken.a
2 months ago
H
happyzappyNew
asked in How Do I

How do I export a ChatGPT chat and convert it to a Google Doc for each individual chat AND add formatting?

I create hundreds of Chats a day in ChatGPT and I want to document these properly as they are created (not just export in the weird export file ChatGPT creates) so is there a way to:1) export each individual Chat from ChatGPT into a Google Document on Google Drive, then...2) automatically format the data - e.g. replace those annoying asterisks ** with actual bold text?The hopeful end goal is to have a clearly formatted Google Doc saved on my Google Drive for each ChatGPT chat I create.Is this possible or am I looking for a unicorn solution?

2
H
2 months ago
P
PascualobatoNew
asked in How Do I

How to automate separating and sending payroll PDFs to employees with Zapier?

Hello community!I'm currently working for a company in Berlin, and we are trying to automatize some tedious process. One of this process is sent the payroll. At the moment, we receive a big Pdf from each City where we work and the manager from each city need to separate this PDF in the different payroll and send to each employee. So I want to at least automatize de process to separate each payroll. And will be amazing also automatize send it separately to each of them . The Payrolls are made it with Datev, and not all have the same number of pages. Each worker have a worker number that can help to after send the payroll. Any suggestions?

2
T
2 months ago
O
overcloud9Beginner
asked in Troubleshooting

Error: Facebook Groups not showing up in Zapier integration

I checked the previous community posts on this problem, but none was helpful. I am connected my facebook account to zapier successfully. I have a private fb group which i want to connect with zapier but it is not showing up after connecting zapier to facebook. In the settings of both zapier and facebook, the groups are not showing up. It shows my pages but not the groups. I have attached screenshots below. I have disconnected & reconnected my facebook account from zapier. Also deleted zapier from facebook and reconnected. But it shows the same pages and not the groups. Does anyone have any idea?This is facebook settings where it allows pages but not groups. The entire setting is missing Zapier is showing the same thing as in facebook 

2
O
2 months ago
G
georgielorenziniNew
asked in How Do I

Error: Google Drive Zap Fails to Automatically Move Uploaded Files

I am trying to move files that are uploaded to one google drive(personal folder) to another google drive(shared drive) I set it up to upload instead of move because I was getting an error with the move option. So when i test it the zap says it passes the test. If I go and manually run the zap it will work but when I upload a file it does not work. It only works if I manually run the zap.

2
SamB
Community Manager
2 months ago
W
WMTBeginner
asked in Troubleshooting

Error: Email content formatting issues when sending to Viator chat section recipients via Zap

Hello,I'm currently in the process of setting up a Zap to automatically send emails directly to the email addresses listed in a designated column. These emails are intended to lead to a Viator chat section with guests.During our testing of the Zap, we've observed that the content of the email appears broken or improperly formatted when received by the recipients.Could you please advise on how we can address this issue and ensure that the emails are delivered correctly without any formatting issues on the recipient's end?Thank you for your assistance.

2
SamB
Community Manager
3 days ago
L
LostMudBeginner
asked in Troubleshooting

Why is BookingKoala to Zapier record data (test) drawing wrong information?

I've previously used zapier to sync new bookings on bookingkoala to populate my google cal - using a test bookingkoala site. However, now that I want to implement this on my actual bookingkoala site, the test data drawn on a zap seems to be showing data to parameters that I do not have on my bookingkoala form. What more, some of the parameters differ in name to that of my previous form (on my test site)The industry forms for both sites are pretty similar, so I'm quite confused as to why zapier is drawing different data from (some) non-existent fields. Test site: https://metroresidences.bookingkoala.com/booknowJust one example out of many, as you can see here, properties such as 'Location' and 'Zipcode' are empty (as they should be) because my Store and Form settings exclude these parameters. However,Actual site: https://cleaningcentre.bookingkoala.com/booknow or https://cleaningcentre.sg/booknowThe same 'Location' and 'Zipcode' properties are filled by the test record created on zapier

2
SamB
Community Manager
2 months ago
B
Blackhawks WillNew
asked in How Do I

How do I notify someone assigned to a Monday.com item that a status has been changed?

Hi,How do I notify someone who’s assigned to a Monday.com item that a status has been changed. Preferably being able to notify them via a monday notification would be best, but will definitely settle for emailing them either through zapier email or gmail email. I’m able to get the monday username via zapier, but I need the email.  This is what I was playing around with. Cheers.

2
Troy Tessalone
2 months ago
G
Geoff GreenBeginner
asked in How Do I

how to only run a zap during certain times of the day

I need a zap to only run weekdays between the hours of 9:30am and 4pm New York time and no other times.  I don’t need a delay, a just need the zap to exit unless NY time is between those hours on a weekday only.I would think this would be simple but I can’t figure out how to do it.

2
Troy Tessalone
2 months ago
B
BrendaNew
asked in How Do I

How do I change message templates on WhatsApp to customize the content of messages sent from Asana?

Olá! Quero enviar uma mensagem no WhatsApp a partir de uma ação no Asana.  No entanto, só aparece pra mim modelos de mensagens prontos. Gostaria de saber como eu faço para alterar a mensagem que vai ser enviada, ou seja alterar os modelos. 

2
Troy Tessalone
2 months ago
K
KiernanBeginner
asked in How Do I

"Get Item by Column Value in monday.com", return ALL items that match (no just 1st one)

I am using “Get Item by Column Value in monday.com”, with an “email” column, searching an email test@test.com for example.  There are actually a few items that match this email, I want to return each of them, but this feature only seems to return the 1st one in the list!  Or is there a way to get item by searching two columns, email AND course for example, I may be able to to it this way.  Any ideas? Thanks! 

2
K
2 months ago
T
The Knowledge JarNew
asked in How Do I

How do I sync new Circle.so subscribers to Beehiiv newsletter using Zapier?

Trying to set up the sync new circle.,so subscribers to Beehiiv for my circle.so community and beehiiv newsletter.   I am stuck on the Create a Subscriber in beehiiv action.  I could only find MAKE automation tutorials and nothing using Zapier.  Any help is highly appreciated.

2
T
2 months ago
DeGerrian Evans
DeGerrian EvansBeginner
asked in Troubleshooting

Podio error: The app returned "Invalid value 0 (integer): must not be less than 1"

I am in desperate need of help with an error message  Podio error: The app returned "Invalid value 0 (integer): must not be less than 1".

2
DeGerrian Evans
2 months ago
V
VaishakBeginner
asked in Troubleshooting

Rows aren't updating in Google Sheets from Slack, and incomplete cards are created in Trello despite successful Zap execution.

Context: I’ve 2 Zaps running Live to automate my Workflow. Zap 1: Whenever I save a slack msg, this Zap sends it to my Google Sheet as a new rowInput from Slack to GS:  Task| Slack Link| Tagged by| Date  (Slack sends Date in this format: 2023 06 08 1:29:30)  (In Google Sheet I’ve formated a Month-Day column that turns the above date to : Jun-8)   Zap 2: Whenever a new row is created this Zap creates a task in trello Input from Google Sheet to Trello  Event in trello: Create card  Card title: Month-Day Column| Tagged by   e.g (Jun 8| Pallav)  Card desc: Check out this task: [Slack URL] Video Link: Loom (please check this)Observation: Zap 1: Initially worked, after that the rows. in Google Sheet stopped updating. The rows are getting pushed but it doesn’t appear here. Zap 2: This works. New cards are created but incomplete.  meaning in Google sheet, you won’t find this row, but it appears in the Trello card.  

2
V
2 months ago
D
dean.bkBeginner
asked in Code & Webhooks

Code by Zapier Python 3.7 Deprecated

Hello,My “Code by Zapier” Python 3.7 steps are marked as deprecatedIs there a way to upgrade to use Python 3.8 without having to recreated the step from scratch?Thanks,Dean

2
D
2 months ago
M
MarkusBeginner
asked in How Do I

How do I include returns in daily sales summary on Airtable?

Hi,I’ve been adding new paid orders to Airtable but have yet to see any returns. I was wondering whether a return is considered a negative order or if there is another way to grab the return information?From the perspective of summarizing daily sales I’d like to also see returns so that I get the full picture. Any ideas would be much appreciated.*Best/Markus

2
M
2 months ago
C
consignsccBeginner
asked in Troubleshooting

Formatter extracting 12-digit strings as intended, but unable to convert into line items

Hello all,Thanks in advance for the help!I have a Gmail → Formatter → Sheets zap set up to: Extract (varying quantity of) multiple 12-digit numbers from the e-mail body, then updating the sheets with multiple rows. While i was able to successfully extract the 12-digit strings as multiple items, it does not return as line items - this is an issue because of the varying quantity of 12-digit strings that the e-mail body might contain.I recently was successful in extracting 5 sets of numbers, and individually inputting the 5 sets of numbers as multiple rows on the sheet. But it limits me to 5 sets of numbers for the zap, while i may potentially have (varying) 1 to 40 sets of 12-digit numbers on a single e-mail body; this method also creates 5 similar rows on the sheet if the e-mail body has only 1 set 12-digit strings.I’m not sure how i could make the initial (transform) extraction return as line items. 

2
SamB
Community Manager
2 months ago
E
Ed MBeginner
asked in How Do I

Is the AI by Zapier action based on Open AI's GPT?

I came across this AI by Zapier action. It seems to do some of the things I currently do but using the ChatGPT action. Can I get more info about how this is different? Is it based on GPT 3.5 or 4, for example? Or something else?

2
SamB
Community Manager
5 days ago
I
InserradNew
asked in How Do I

Service Ticket to Shippo Zap - Auto populate assigned contact's Shipping info

Hi All, I’ve created a Zap that creates a Shipping label in Shippo once a Service Ticket is generated. Right now, the easiest way to make it work was to create my own custom properties within the ticket to correlate to specific needs for a shipping label ie: Street address, city, state, zip. It works nicely, but we have to input the address info manually. Just wondering if theres a good way to create an association(s) with an assigned contact’s address to auto populate these properties.Thanks in advance! 

2
ken.a
2 months ago
I
InsightDrivenParentingNew
asked in Troubleshooting

Zapier doesn't recognize Facebook Groups for sending videos to the Google Drive folder.

I am trying to set up a zap which will send new videos from my facebook group into a folder in my google drive.It is connected to the correct facebook account I am an admin in the group in question The zapier app has been added to the group  I’ve allowed all permissions When I go to select a group, it says none are available. Bottom right - all results are loaded - no options are availableI’ve clicked refresh results in the zap - nothing I’ve refreshed the actual webpage itself - nothing I’ve tried logging out of facebook and zapier, then logging back in to both - nothing I’ve tried deleting the connection from zapier to my facebook, then starting over and reconnection - nothingCan somebody please help before I lose my mind?Thanks,Kristin from Insight Driven Parenting

2
Troy Tessalone
2 months ago
F
FabdelSgnBeginner
asked in How Do I

Automating bookings from online agencies

Hello First of all I would like to thank anybody who would be able to take the time to support me, as I am a new user and my questions may sound a bit basic. I run a cooking class business and I receive booking from different online agencies, such as Klook, Get your guide, Viator... Each of those agencies sending me emails when I have a booking and each agencies having their own templates. What I am trying to achieve is to be able:- to automatically create an event in my shared calendar when I receive a booking (I use Teamup but I could use Google Calendar if that helps).- to automatically delete an event when I receive a cancellation from the agencies. What I did so far was to take the first agency, creating a mailbox with an email adress of Email Parser, define my template with the booking message used by this agency to create the fields, and create my Zap. The questions I have is:- shall I create one different mailbox (so forward my booking confirmation to a different mailbox on Ema

2
F
2 months ago
S
sts0868New
asked in Troubleshooting

Meta quit Facebook Group API - and now?

As Zapier mentioned in an mail, meta will quit the Facebook Groups API. That means from April on we will not be able to use that API with Zapier anymore. When I read it right, meta indroduces a new API - does anybody know if Zapier can use the new one again? If not, will there be any workarounds to still automate a Facebook Group post in any way? This Zapier App is the main reason why i registered at Zapier. Without that possibility I have to cancel my susbscription. 

2
SamB
Community Manager
2 months ago
E
Ellie GraceNew
asked in How Do I

How do I create a zap to trigger Squarespace purchases to a group in Mailerlite?

I am trying to set up a Zap between Squarespace and MailerLite so that when new purchases are made, customers are added to a group on MailerLite. From what I can see, the only trigger option for Squarespace is new form submissions.I noticed that on Squarespace products, during checkout, there is an option to include a custom form, which I added. However, I am not picking up the form on Zapier. Does this not fall under the ‘New Form Submission’ trigger?

2
Troy Tessalone
2 months ago
Terms & Conditions