Skip to main content

Get Help

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

28593 Topics
P
philpBeginner
asked in How Do I
App to retrieve csv from url

Hello all -  I am working on building a zap that will retrieve a csv that is hosted online and pull the data over to a google sheet. However, whenever I do this, it takes all the data from the csv and crams it into one cell. The desired output would preserve rows and columns from the original csv. I’m currently using Scheduler → Webhooks → Google Sheets. Thanks for any input!

5
D
4 years ago
M
MapsedNew
asked in How Do I
Integration between Gmail and sendpulse

I am trying to create a zap between Gmail mailbox and Sendpulse. The idea is to add a new subscriber ( within a specific list) when I receive a notification email that contains the customer's name and email. Can I use my personal mailbox (free account)? During my tests I always have this error: We had trouble sending your test through. The app returned "Bad request". This usually happens when your Zap is missing a required field or a field value isn't in a recognized format. Hide details How to fix We made a request to api.sendpulse.com and received (400) Bad Request. thx a lot for your support. P.M.

1
nicksimard
4 years ago
C
ChrisRagerBeginner
asked in How Do I
Adding Twilio "account" to my Zapier

I have an old Twilio account that needs to be removed and new one in it’s place.  When i authenticate it I get this error below. I am admin on both and have an upgraded account with a phone # and cc in place. Any suggestions?  Zapier held desk is non responsive   We hit an error adding your new account authentication failed: The app returned "The requested resource /2010-04-01/Accounts/support@iamacomeback.com/IncomingPhoneNumbers.json was not found". This usually happens when a field value used in this step is missing or we're unable to find some information in your connected app or service. Make sure that the information exists and that the field values used in this step are entered correctly. We made a request to api.twilio.com and received (404) Not Found. Make sure you click "Allow" or "Accept" on the permission popup Double check your Account has the correct permissions Check out our help docs for more information

4
C
4 years ago
Matt
MattBeginner
asked in How Do I
Best app to create QR Codes

I have a need to create qr codes (action) after a trigger. What type of experience do others have with this? Apps you’d recommend?   Thanks.

2
Matt
4 years ago
W
westernlettingsNew
asked in How Do I
Asana and Office 365

I’m brand new here and looking for advice. I set up an account in Zapier to try to populate our shared office 365 calendar when we add/edit/delete tasks in Asana.  When I create a task in Asana I get a new task in Office 365, but when I change the due date in Asana, I get another new task in Office 365. I’m assuming that I’m not the first person to encounter such an issue but I can’t see any easy way to fix this.  There is no “when I modify in Asana then modify in Office 365” option. Can anyone help?

1
Liz_Roberts
4 years ago
A
alanjaramilloNew
asked in How Do I
math calculations based on inputs within other cells

I am trying to use typeform in google sheets, but I cannot figure out how to have math calculations done based off of the inputs given through the typeform survey i have created. We have tried to manually input the equations into the google sheet, but it seems to throw off zapier, so it skips the rows we need to information to go to.

1
Liz_Roberts
4 years ago
C
CijiCGambleBeginner
asked in How Do I
Jotform to Google Docs Template (Changing from semicolon to comma)

I have a Jotform survey with questions that allow for multiple choices. I created a Zap that goes to a Google Doc template and when I choose multiple options for a question the selections come in with semicolons (;) but I am hoping that they come in with commas instead. Is there a way to do this?

2
C
4 years ago
H
HBSMobileBeginner
asked in How Do I
Is their a way to create a Zap between Trello and my Clipboard?

Is there a way to use Zapier to take data from a Trello card and populate my clipboard? Here's what I'd like to do. When a card is moved to a Contact Client list, I'd like to contact the client. But each client has different methods of preferred contact--some want an email, some want a text, some want to be messaged back on the FB Messenger thread. Right now, I created a Zapier Zap that writes out the message I want and populating it with data from the card (i.e. Hi _Name_, the book you ordered _title_ etc etc) and creates a Draft Email in Outlook, which works only some of the time because most don't have the email field populated. So what I'm then doing is jumping over to Zapier to see the Failed Zap report and then copying the text from there to then paste into my text message or whatever. Is there a way to have that instead populated into my Clipboard so then when I move a card I can then just go to my text message or FB or whatever and paste in what it gives me?

3
Danvers
4 years ago
T
tiagoBeginner
asked in How Do I
Javascript Exception: `Error: certificate has expired` - I am not able to run a test, why is that?

Hi there,  I have a Zap that is connecting an Airtable base with google slides. I am constantly having this error message while performing the test:  `Javascript Exception: `Error: certificate has expired`.` Do you have any idea why?    The interesting thing is that the file get’s generated, however the slide doesn’t get populated?    Could someone point me in the right direction?

3
Danvers
4 years ago
M
MFRBeginner
asked in How Do I
Google sheet export to update contacts

I’ve think i have a similar problem. My question: I have a google sheet export with our customer information from our custom made CRM (kinda oldskool)  Its got 260 columns and about a 1500 rows.  I want to update my contacts in Active campaign if anything changes in our CRM. So I’ve copied alle the fields to AC, set up an export and connected through a zap. My plan is to;   -weekly export all this data.  -delete the data inside, add the fresh export -when a certain cel changed, it triggers   I dont want Zapier, thinking ive added 1500 rows (on a weekly basis) Do I just turn of the zap, do my thing, and turn it back on?  (and does every change in a cel counts as a task?)   Hope to hear from you!  Cheers, Milko Amsterdam  

1
Danvers
4 years ago
W
wargabBeginner
asked in How Do I
node's fields - owner ?!

Salve, I always get this message when i want to update a zap :   Problem updating Node. A node's fields may only be edited by its authentication's owner.     Can't update. Does some know why ?

4
Danvers
4 years ago
M
mrbreadNew
asked in How Do I
change number

I want change number original number :  010-3333-1111 change number : 01033331111   help

1
AndrewJDavison_Luhhu
4 years ago
H
hugh_hopkins123Beginner
asked in How Do I
Unable to create a lookup table

I have been using lookup tables for a while now, however, since the new Zapier user interface, i don’t understand how to create a new lookup table! I understand that you need to have a “a table that will be used for the lookup - keys on the left and values on the right” - however, in the new user interface, there is no where to enter the table? its just a free text box?   Am i being really stupid? Where do i enter the different values? All my existing look up tables are working fine, however, i can’t even see the tables for them either!  Any help would be amazing!

4
H
4 years ago
B
BoozedBeginner
asked in How Do I
Status 400 - Trello - add member to card

Hi,  i'm running into problems building a zap that creates a Trello board and adds a member to the first card (can't find how to invite member to board, so i'll add them to the card as a headsup that the board is created). Current structure: Run Javascript (get info for board from softwares API) Filter Copy Board in Trello (I use a couple of template boards loaded with cards and power ups) Find list on a board in trello (find list name on board id from previous step) Find card in trello (find card name in list id and board id from previous steps) Lookup table in formatter by Zapier (translates user ID's from API in step 1 to name in Trello) Find Member in Trello (Searches trello for person in previous step) Add Members to Card in Trello (Board ID from step 3, Member ID (or name or handle, tried them all) from step 7, List ID from step 4, Card ID from step 5) The last step gives me the 400 errorThe app returned "invalid member". This usually happens when your Zap is missing a required f

2
B
4 years ago
A
andyNEXTNew
asked in How Do I
Airtable New Record Trigger when reaching the max record cap

Hi Everyone,   I’m creating an email digest based on the New Record trigger on Airtable. Approximately 500 new records are added a day and a dozen or so custom digests will parse through each new record, filter to match conditions, then email the correct recipient a custom digest personalized to them. I will be running into an issue with the max record cap of 50,000 records soon. One solution I thought could work was to copy and paste the data into a different table/db, then completely clear the base that the Zap is pointed to so that new records could be added from the first row. However, this doesn’t seem to trigger the New Record trigger. Does anyone have a workaround for this?   Thanks!

1
Danvers
4 years ago
J
JowenNew
asked in How Do I
New to Zapier: Overwrite Google Sheet with daily Gmail spreadsheet attachment in htm format

Struggling to understand the bridge I’m missing here. I receive a daily email with a Report.htm attachment. I’d like to overwrite an existing Google sheet with the detail in that attached report.   I’ve started with New Attachment in Gmail and seem to have that setup fine. then, I was moving to Update Spreadsheet Row in Google Sheets but can’t figure out how to connect the actual report data and have it fill in the sheet. I do not want to keep the previous data.  Do I need to use the Formatter as a second step or a first step? If either, which Utility option do I select? Thanks in advance for your patience!

1
Danvers
4 years ago
P
PM TeamNew
asked in How Do I
Trying to add a Calendly invite to another Gmail calendar

Hi,    I’m trying really stuck here and my boss definitely not happy. I’m trying to make it so that when a Calendly invite is created, she is also included in the email. I keep getting an error every time   PLEASE HELP! I need to get this set up! Moderator note: images cropped and/or obfuscated to remove personally identifiable information.

1
Danvers
4 years ago
M
marshallbeyerNew
asked in How Do I
Check Off Tasks in Google Tasks

Currently, I have a zap set up where if I put a task into Google Tasks it zaps it over to my Things 3 inbox. The only issue I have with this is that now I have the task in two places. Is there a way that I can have it check off the task in Google Tasks after it sends it over to Things?

1
Danvers
4 years ago
R
RbravoBeginner
asked in How Do I
Adding records to Airtable depending on field value

Hi! I have a Table with an “email” field already populated with some email addresses, and I would like to implement the following workflow: when a new email arrives (gmail inbox) Find the “From: email address” in the table. if there is a match, create a new record with the email content (subject, body etc.) if no match do nothing so only emails from people already on the list are stored. When using “Find in Airtable” as Step 2 and the “Create record” as Step 3, I don’t see how to do to create the record only if Step 2 found a match. Currently all emails are stored, as if the Find step was ignored.   On a different Zap I succesfully did an update of a record based on a match with the email address, but can’t figure out how to create a record instead. any clues?   thanks a lot!    

2
R
4 years ago
J
JohnLapNew
posted in How Do I
webhook POST - problem formatting raw payload

Actually, reading your example, I have it fixed.  Thank you   I have a similar problem, except, I can’t seem to get the RAW payload I create to work. It appends the “data:” &”:” before the open bracket which appears to be failing at the API on the other end.  Is there a way to remove those labels.   Thank you in advance. First time on here, so hopefully, I am not breaking any etiquette.

1
Danvers
4 years ago
S
SJ Innovation LLCNew
asked in How Do I
QuoteRoller trigger "Proposal Accepted" is the only trigger that would make sense

Hello!   I was trying to connect QuoteRoller with HelloSign or other convenient online document signature service. I want my client’s to sign the proposal when they want to accept it. There is no such trigger available when I try to connect QuoteRoller through zapier. Please suggest if there is any way to achieve this through Zapier or any other platforms.   Thanks.

1
Danvers
4 years ago
M
mozaydevNew
asked in How Do I
Trouble loading 'Trigger Rule' data in step 1: Unexpected token < in JSON at position 0 [Woocommerce]

We’re migrating our legacy Woocommerce integrations over to the new format, and Zapier can’t retrieve any Trigger Rules after logging into our development website (which has SSL), but I have no idea what is causing this error or what to do about it.

3
nicksimard
4 years ago
E
EflatsBeginner
asked in How Do I
webhooks

Hi I recently started a new webhook zap with hopes to help track job costs for my company. I’m using jobnimbus as my crm where work orders are created and maintained. When a work order hits a specific status my webhook will pull specific data into a google sheet to database the info for later query. This zap is working however not pulling some critical information and the dates are showing up as an unknown 10 digit number I can’t seem to find any correlation to an actual date. Any help would be fantastic.  

3
nicksimard
4 years ago
R
redearmedia
asked in How Do I
Create a Google Sheets Worksheet AND Create Spreadsheet Row(s)

Hi all,I can&apos;t seem to figure out which way to do this. I&apos;d like my Zap to take some nominal form data from Gravity Forms and spit it out into a Google Sheets file. But I want each new form to create its own worksheet. I&apos;ve got step one, but I noticed that the &quot;Create Worksheet in Google Sheets&quot; step does not include the ability to input row data.Assuming I have to create another step that then creates the row data, how can I programmatically select my brand new worksheet from the last step? It won&apos;t have been created yet and Zapier seems to want an existing Worksheet during setup.I&apos;ve tried setting a Custom Value for the Worksheet ID based on the ID from the previous step, but Zapier is throwing an error. Either I&apos;m doing this incorrectly, or it won&apos;t work this way. Any ideas?cc: @AndrewJDavison_Luhhu

3
C
4 years ago
E
EmmaGandBeginner
asked in How Do I
How will a Hubspot dynamic list be managed by Zapier?

Hey there ! I’ve created a Zap to integrate my new contacts in Hubspot into a Mailjet mailing list. Question : will changes in existing contacts also be captured by Zapier and update my existing Mailjet list? Thanks a lot !

3
nicksimard
4 years ago
Terms & Conditions