Skip to main content

Get Help

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

28148 Topics
O
ofakiehNew
asked in How Do I
how to pick any card in a list

Dear All,   Im trying to update a cards name with a number between brackets when it is entered to a certain list in my Trello board, however zapier is not giving me an option to set it for all cards that enter the list, its only giving me an option to choose a card in that list that already exists, can someone please let me know how to choose the option of all cards that enter the list should be updated.   Best Regards, Omar Fakieh

1
steph.n
4 years ago
B
BartezzNew
asked in Troubleshooting
Trigger an action when a due date is reached

I am using Investment Dominator (a real estate CRM tool) and Slybroadcast (tool to send out voice messages).  The idea is to send our clients an automated message, after the due date is reached (they have received an offer). In my CRM tool the trigger event is that I update the record to offer sent status, but the action (send message via Slybroadcast) should not happen immediately. It should only happen, once the due date is reached. The Zap works well without this condition but I was not able to setup the ZAP in the way, that the action should only be triggered once the due date is reached.  My thinking was to add a filter function: Only Continue If… and then insert the due date into the first cell and use also the “date/time” feature but that doesn’t work. In that case it seems I need to add manually a target date in the last field. Then it works, but actually I want that this should happen automatically. The ZAP should automatically recognize once the date is reached and execute

1
steph.n
4 years ago
B
BoxNew
asked in How Do I
Is there a way to Auto run?

I’m using a Zap to get Trello suggestions from discord, and everything is set up. However, it seems like I have to manually run it every so often to for it to actually link. This is fine but it would be easier if there was some way for it to automatically run whenever there is an input… If someone can either tell me how to do this, or explain that there is no way to actually do this, I will appreciate it.

2
Liz_Roberts
4 years ago
S
Simon_blueprintNew
asked in How Do I
Extract raw body from webhook : SyntaxError: Unexpected token o in JSON at position 1

Hi there,   I’m trying to extract some data from a Webhook. The output looks like a JavaScript object however I’m not able to navigate through it. When trying to parse it data = JSON.parse(inputData); I have the following error: SyntaxError: Unexpected token o in JSON at position 1 What does it mean?   

1
steph.n
4 years ago
M
MSadeghiBeginner
asked in How Do I
Pinterest Title

I am trying to post from google sheets to Pinterest. Typically a pin has Title, Description, Image and URL. The integration only has description, image and URL? How do I pass on the title?  

11
W
3 years ago
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
4 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
4 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
4 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
4 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
4 years ago
A
ajensenNew
asked in Troubleshooting
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  

33
SamB
Community Manager
3 months ago
G
ghirschBeginner
asked in How Do I
Substack

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

4
Danvers
4 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
4 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
4 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
4 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
4 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
4 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
4 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
4 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
4 years ago
D
duxhomeBeginner
asked in How Do I
Does Zapier support importing Ninja form into Salesforce with Person account?

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.

4
SamB
Community Manager
1 year 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
4 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
4 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
4 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
4 years ago
Terms & Conditions