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 Zapier University 101

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

How Do I...? Troubleshooting Popular Apps Q&A 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 Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell

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

Interest Areas User Groups

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

Zapier University 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.

15717 Topics

F
FrancisBeginner
asked in Code & Webhooks

need some help to finish a Pyhton script !

Hi !  I created a first Python code to try to organise datas for a table. It works well so I am able to organize datas in the right order. The pb is that I need to split this big table in sub tables grouped by the value DOSSIER and i don’t know how to do that ! If someone gets an idea !  Many thx Francis import datetimedates_obj = []for i in input_data['dates'].split(','): dates_obj.append(datetime.datetime.strptime(i, "%d/%m/%Y").date())event_list = list(zip(input_data['events'].split(','),input_data['dossiers'].split(','),dates_obj,input_data['descriptions'].split(','),input_data['qte'].split(','),input_data['avocats'].split(','),input_data['types'].split(',')))sorted_events = sorted(event_list, key=lambda item: (item[1],item[2]))out = []for e in sorted_events: out.append({'event': e[0],'dossier': e[1],'date': e[2].strftime("%d/%m/%Y"),'types': e[6],'description': e[3],'qte': e[4],'avocats': e[5]})return { "events": out, }  

3
nicksimard
Community Manager
2 years ago
L
LPATNew
asked in How Do I

setting up a subscription based discord channel

I am trying to set up a paid section in my discord channel. I am looking to add a reoccurring subscription button linked to paypal. When the customer signs up for the subscription service and competes a successful sale in paypal then zapier would assign them a premium role.Any help would be greatly appreciated. 

1
steph.n
2 years ago
D
DrewPBeginner
asked in How Do I

Trello due dates not being passed to Zap

I'm creating a zap that reads a Trello card and creates a Google calendar event. I can read the data from the Trello card mostly without an issue however, there is no due, due date, due reminder. This means that the required end date cannot be populated based on the data in the card. I've made sure that the card has a date and has the reminder. Set I've tried a date in the near future and a date about a month out. I've hit the refresh fields button, but I've also allowed 45 minutes or so for all of this to refresh.   Has anybody run into where they were not able to pull the due date from Trello and then were able to fix that?

2
AndrewJDavison_Luhhu
2 years ago
B
BrendenNew
asked in How Do I

Connecting Act-On to pipedrive

Hello!    We are looking to hire someone to create two Zaps from Act-On to Pripedrive. We use Act-On as a lead qualifying tool on our website then piperive is used as our CRM right now. We would like to implement the following.    When a lead gets to a certain qualification score in Act-On a new deal with contact information is pushed to Pipedrive and assigned to a contact.   We would like the clients history that's in Act-On to be pushed to and connected to Pipedrive either in an Iframe or an autopopulated field.    If you can help us out on either or both of these that would be amazing and we look forward to engaging your services.    Cheers, Brenden  

2
jesse
Community Manager
2 years ago
K
kmdguyNew
asked in How Do I

Download entire mySQL table/database to Google Sheets? Not just single row.

Hi there, I’m checking out Zapier for the first time and I have it connect to my mySQL database and Google Sheets. The single row import works fine, but my goal is to pull in either an entire table at one time, or an entire database at one time. Is there a way that this can be done? I have many databases each with identical tables in them and I’m looking for a way to import all of that data cleanly into Sheets. Not line by line. Thanks.

1
Danvers
Community Manager
2 years ago
A
ajensenNew
asked in How Do I

Cannot connect to files in Google "Shared Drives"

Dear Zap Team, I’m trying to append text in a Google Doc with information from Monday.com Pulses. The Zap works just fine for Docs in “My Drive” but not for Docs in my company “Shared drives”.  I followed instruction from another post (https://community.zapier.com/ask-the-community-3/new-google-drive-zap-can-t-find-shared-drives-1067) and plugged in the folder ID into the Customize Text. Again, this works for “My Drive” but not “Shared drives”. Are there specific setting I need to adjust on the Shared drive to allow Zapier to access the files? Thank you, Adrian  

29
pesmonde
9 days ago
G
ghirschBeginner
asked in How Do I

Substack

does anyone know if zapier will eventually make a zap for Substack?

4
Danvers
Community Manager
2 years ago
M
mzerbibBeginner
asked in How Do I

Paradiso LMS Integration

Hi, I’m looking for a solution to connect this app with Hubspot.   I’’ve found a blog article about the  Paradiso LMS paltform (https://zapier.com/blog/updates/570/paradiso-lms-integrations) but no  Zap seems to exist. is this connector no longer active?   thanks Michael

1
adamsmartschan
2 years ago
J
janbNew
asked in How Do I

How to set conditions If a variable is not found.

Using ConvertKit and Clickfunnel App on this one. On ConvertKit when an email is tagged with sma-purchased. It will tag also the same email on  Clickfunnel. The setup is like this because there are other forms we have aside from  Clickfunnel form. So the zap is setup like this. So to do this I setup the zap like this. Step1: When this happens - When this tag added to email on ConvertKit Step2: Do this - Find Contact Profile  Email in Clickfunnel Step3: Zapier Path  - Path A: IF email exist add the same tag on the email in Clickfunnel.   I'm trying to search for an email on clickfunnel. If email is found it will be tagged. But if not, will the zap ends there? Or it will cause an error if its not found?    

1
steph.n
2 years ago
B
BiskitNew
asked in How Do I

New Trello card from Facebook friend add?

Does anyone know if it’s possible to create a new Trello card when someone accepts your Facebook friend request, or you accept someone’s friend request?

2
Liz_Roberts
Community Manager
2 years ago
T
testdevfompBeginner
asked in How Do I

Receive SMS

I want to automate a process where I send a SMS to a group of people based on a specific event.  One of those people has to answer and take care of that event. A lot of the SMS Apps say they provide a service to send and receive SMS. I tested now many of them...they all only allow sending of SMS. I can only continue if I find a service that really is able to send to a group of people and receive also an SMS answer.  I hope for your help

4
nicksimard
Community Manager
2 years ago
U
UK_NatalieBeginner
asked in How Do I

Find / Create Trello Card creates duplicate

Hi, I have set up a new Zap integrating ScheduleOnce Booking with Finding/Creating a new card in Trello. The behavior I want is: the first time someone books in a Sales call via ScheduleOnce they get added to the Pipeline Board. However when they are later converted into a client and then book in a subseqent 1:1 session (again via ScheduleOnce but in a different Booking Form) I don’t want a new card created (currently in Zapier you can’t differentiate between different ScheduleOnce Booking Forms) Ideally it would update the existing card with new information from the latest session booked in, but I”ll settle for no duplicated cards! I can’t get it to do this. Instead it creates a new card initially, but when a subsequent booking comes in for the same client (I’m using their email address as the Organisation ID) it just creates a new card. What do i need to do / change in order for it to FIND an existing Card and: Not create a duplicate update the original Thanks.

3
steph.n
2 years ago
P
pianoclubhouseNew
asked in How Do I

Keap/Infusionsoft - removing ta

Hello. I’m fairly new to Zapier, but catching on quickly i believe. I am using Infusionsoft, and am easily able to create records and add tag(s) via the zap. What I can’t figure out is how to to remove/replace an existing tag. For example I have someone tagged a “Paid Customer”. When the cancel, i want Zap to go into Infusionsoft and delete the “Paid Customer” tag and add a “Cancelled Customer” tagl I can’t find that functionality in the Zap settings. Any help or workarounds would be appreciated. Thank you.

6
KelseyBratcher
2 years ago
D
dannyzavalaNew
asked in How Do I

CRM for Project Management and Sales

Discussion: Does anyone know of a functional CRM that can handle a sales pipeline AND project management? It seems that only one or the other exists.  All of our sales turn into projects, and the projects take anywhere between 6 months to a year.  I need a CRM where I can manage both. Robust reporting would be ideal, as well.    Am I asking for too much?

1
steph.n
2 years ago
M
Michael.ThomasBeginner
asked in How Do I

Extracting a HTML Table from a Cell

Hello All,   I have an HTML Table that gets exported from an HTML Page.  The HTML code and Table in embedded into one cell - i.e. A1 on a google sheet.   Does anyone know if there is a way to extrapualte this data back into rows & cols in a google/excel sheet?   I guess this would be similar to the importhtml function but I cannot get this to work.   Any Ideas anyone?   Thanks Mik    

1
AndrewJDavison_Luhhu
2 years ago
D
duxhomeBeginner
asked in How Do I

Salesforce Person Accounts

Hi I work with a charity and we are looking to import our online Ninja form into Salesforce, but we use Person accounts rather than standard company accounts. Can anyone tell me if Zapier supports this please? I cannot find any documentation on this? Thanks in advance.

3
Danvers
Community Manager
2 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
Community Manager
2 years ago
jstele
jsteleBeginner
asked in How Do I

Zapier useage forecasting tool?

Before I upgrade to the higher Zapier plan, I wonder if there’s a spreadsheet/tool out here that would enable me to easily forecast the unit economics for using Zapier.  In other words, if a new trialer on my platform consumes X number of Zaps/Tasks during their 14-day trial, how can I forecast future usage and Zapier costs overall.  Thank you in advance!!   -Jason CTO | Cobomba.com

1
AndrewJDavison_Luhhu
2 years ago
P
Paul EnvizzoBeginner
asked in How Do I

Is there a maximum number of gmail emails triggered by a zap(s) before Google flags as spam?

Is there a maximum number of emails I can trigger/send before google starts flagging my gmail account as spam? I have heard max requests to Gmail API is 500 / email address / day, but not sure if that’s a thing.   Anyone have experience with this? I’d like to be able to trigger a maximum # of emails per day via Google Sheet → Gmail zap(s) but don’t want to get the work emails of my team members black listed or flagged, etc.    Thanks in advance!

2
P
2 years ago
R
rikmarisBeginner
asked in Code & Webhooks

How to remove ctrl-char code 13

Hi everyone,   I have an issue to make an post api call to HubSpot. The value that i want to send gives this Invalid input JSON on line 16, column 17: Illegal unquoted character ((CTRL-CHAR, code 13)): has to be escaped using backslash to be included in string value Does anyone have any idea or tips or scripts to remove all these?

11
R
2 years ago
J
josefBeginner
asked in How Do I

how do i undo changes & view task history on test runs.

I’ve just lost a lot of HTML coding, which is annoying for me as I can’t really code.   How can i undo a change? I was using the Gmail task.   Also, how do i view task history on task test runs? I may be able to retrieve the code if i can locate this.

4
toddmoy
2 years ago
S
Shayla.waterBeginner
asked in How Do I

Adding GST/PST to Square transactions

Hello, I’m setting up a zap to import transactions from Square into Wave Accounting. Does anyone know how to set up the zap so that GST and PST are imported from the transaction? Thanks, Shayla

4
S
2 years ago
N
NarainMandyamNew
asked in Code & Webhooks

Posting directly to Zapier from PHP

I wanted to know if it was possible to directly POST data to a zap from a website, and then have zap format that data and send it to an app.  The form I am posting from is written in PHP. Is there an API that can help make this easier? otherwise I would have to post to an app that Zapier can use.  I basically want to cut out the middle man.    

2
ChrisP
2 years ago
J
jaonphotoBeginner
asked in How Do I

Is there a way to automate dropbox file requests?

Hi I managed to create zap that adds a new folder to my Dropbox and names it with the customer name and email address. I need a way to automatically send a Dropbox file request to each customer folder as they are created. Is this possible?  Thanks

6
christina.d
Community Manager
11 months ago
A
arkhamknighthellBeginner
asked in How Do I

Tag IDs Monday.com

When using the new Monday.com Update Item Multiple Column Values in monday.com Automation I run into problems when trying to update the tags field. Say for example I enter: tags2 for the key and   {    "tag_ids" : [73]  } for the value. I get a vague The app returned "Internal server error". from this. Also on a side note does anyone know how to find the tag_ids as well.

5
A
2 years ago
Terms & Conditions