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.

25704 Topics

C
Caroline PokornyBeginner
asked in How Do I

How to get address + phone zapped from GetResponse form

I have a landing page with a form that collects name, mailing address, phone number, and email address. I’ve used Zapier to connect that landing page to a Google sheets so that information would be easily collected when anyone signs up in the form. However, Zapier is only zapping the name and email address over to the Sheet, not the mailing address and phone. How can I change this to include all my form fields getting zapped over?  Thanks! 

3
C
1 year ago
4
4pillarfundingNew
asked in How Do I

Extract Specific Cells from Google Sheets and Map them to CRM

Hey All, I am having an issue doing the following. I am trying to get a specific range of cells in column A and the data that representing data of that in column B from Google Sheets.  I have tried “Lookup Spreadsheet Row in Google Sheets” with “Get Many Spreadsheet Rows (Advanced, With Line Item Support)” in Zapier but it is very difficult to get the data from Column B out individually.  The date below starts in row 13 below a table which adds more difficulty to it. Is there a better way to do this? Business Start Date 02/26/2019 Nature of Business Emergency Medical Services Credit Score 598 In DataMerch No Court Records No Business State TX Default   Tax Liens No Bankruptcies No Criminal Records No Credit Utilization 0.00% UCC's   Website  

3
jesse
1 year ago
H
HemeaBeginner
asked in Troubleshooting

PostgreSQL trigger on my database but don't trigger on zapier

This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting.Hello everyone, This one is a tricky one and i can’t get to know what’s happening. I have a zap with a postgre SQL trigger “new row custom query”. The zap triggers approximately 100 times per day and some row that appear in my database don’t trigger in my zap and i can’t find the any trigger for the following row (see the example in the screenshot)  Does it have something to do with how much data you can send to zapier ? 

4
jesse
1 year ago
F
freshairnyBeginner
asked in How Do I

How do I create a contact in Follow Up Boss, enter their information, and activate an action plan when a site visitor completes a questionnaire?

I’m trying to figure out how to set up a connection between 123FormBuilder and Follow Up Boss (FUB) so that when a person completes a questionnaire on my site, it creates a contact on FUB, adds the information to their profile, and triggers an action plan on FUB. Anyone have experience setting up this sort of Zap?

6
chanelle
1 year ago
K
keanBeginner
asked in How Do I

How to Use Zapier to connect 2 different Intercom workspaces

Hi, I am new to Zapier and just wondering if I can use Zapier to connect 2 different Intercom workspaces so that customers from one Intercom workspace (say A) and chat directly to the agents from Intercom workspace (say B) in the intercom messenger A? Thanks. Regards, Kean  

4
chanelle
1 year ago
R
ReyrrBeginner
asked in Troubleshooting

Orders from Shopify are being sent as 558:00:00 instead of just 558, causing Google Sheets not to recognize it as a number.

Hi, We have been having some issues with our Zapier integration and I wanted to reach out to see if you could help us troubleshoot. Basically, the orders are being sent as "558:00:00" instead of just "558" from Shopify. This is causing problems because Google Sheets doesn't recognize it as a number.Do anyone have any idea why this might be happening? Any help you can provide would be greatly appreciated. Thank you in advance! Best, Benjamin

17
jesse
1 year ago
P
pg0112Beginner
asked in Troubleshooting

Squarespace form Select list to Salesforce opportunity picklist

Hi thereI have seen a version of this question here and tried the Utilities Formatter with limited success. My squarespace form has several fields and one field that is a “select” field with three options. I am trying to map it to a custom opportunity field in Salesforce with the same with three picklist options. I have created a lookup key and a lookup table with 3 options. When the Zap tests itself it creates an option one opportunity in Salesforce. When I test it in real time with the actual squarespace form and choose option two it it creates an opportunity with the fallback value instead of option two.That seems to indicate anything besides option one isn’t recognized. Ideas? thanks for your help~ 

9
jesse
1 year ago
M
Magpie2000kBeginner
asked in How Do I

Creating Xero multi line invoice from Google sheet

Hi I have tried and tried reading and following guides but cant get there,I have a google sheet in each row is an invoice request with Name | email | Product 1 (quantity) | Product 2 (quantity) | Product 3 (quantity)| unique id | telephone numberI Have made it pull single line items into Xero ie pulls product 1 and match in Xero with product and as such I get a single line invoice that is correct but I cannot seem to do this for all the products requested ie multi line invoice.The google sheet does not have prices I need to link this as I have done on single line to the products in Xero Any help would be great

4
M
1 year ago
V
VanceAnCBeginner
asked in How Do I

Action Step - update Trello Card - increase numeric field by 1

We use Trello for design project tracking. When we have a proof ready for a customer, we drop the file on the Trello card, Butler automatically moves it to the “Proof Ready” list. Then Zapier takes over and sends the proof to the customer. The next step in the Zap moves the Trello card from the Proof Ready list to the Proof Sent list. It also updates the custom field, “Proof Sent” with the current date and time. There is also a custom field designed to track the number of times a proof has been sent. To explain, if a customer hasn’t responded to the proof within 2 days, Butler is set up to automatically move the card into the “Proof Ready” list  - that way Zapier sends the proof again. I don’t want to continuously send proofs, so, I have a custom numeric field set up as a counter so that Butler won’t repeat the process more than 3 times. However, I can’t figure out how to make Zapier update the custom field by 1 when it runs. Any suggestions?

7
V
1 year ago
V
Vincent34axeptioBeginner
asked in How Do I

Gmail file -> Google sheet

Hello everyone,I am looking for a process to retrieve data from a CSV that I receive every week by email.I automatically receive this file by email and it has 34 columns.Only 5 are useful for me.However the file is over 250kb and therefore I cannot format with zapier my file.The idea is that I can recover only the good columns to lighten the file but I did not find any process.Any ideas for a process? Here is my process so far:Find new attachment (Gmail) --> Upload to google driveNew Google sheet in a Google drive --> Create Spreadsheet Row(s) in Google Sheets I tried several different processes but none worked...

2
V
1 year ago
P
Prash_GINew
asked in How Do I

Create a Linkedin Matched Audience with a list Company fields (Company Name / Website / Country )

Hi Community, I am trying to automate creating a Linkedin Matched Audience (using the Linkedin Matched Audience integration) - but I cannot see an appropriate action to this do.I’ve tried the Linkedin Matched Audience integration - but it seems I can only add audience members by “Email” address.In Linkedin Campaign manager it is is possible to create an audience by uploading a CSV file containing the Company Name (the company that an employee works for), as well as the company website, linkedin URL, country etc.E.g. “Joe Bloggs Limited, jobbloggs.com, linkedin.com/joebloggs, UK”Is it possible to add an Action to achieve this? Can I extend the existing Linkedin Audience integration to include this functionality (e.g. contribute to it?)The ultimate goal is to “programmatically” create these audiences from within my app. Unfortunately I cannot use the Linkedin API directly - hence why I would like to use Zapier to achieve the goal. Thanks!

2
P
1 year ago
L
Lucas SaldanhaBeginner
asked in Troubleshooting

Zap filtered (not pass) is counting as Task count

Hi, I've already sent an email to the support but maybe I'm missing something.I've a Zap that is triggered for any update on a Order in Booqable integration. And at the beginning (first step) is a filter that let continue or not. What I'm seeing is that the trigger or the filter (not passing) is counting as task against my monthly quota.Here is my Zap as my first step (after the trigger that is NOT counted like is mentioned here: https://help.zapier.com/hc/en-us/articles/8495906379405-How-are-tasks-counted-in-filters-Here is the beginning of the Zap: Here is my Zaps Runs History:  You can see that the "Delete Venda (Sale) no CA" has almost all the 2K tasks counts. But 99,99% of those don't pass the first filter and it's stopped. Either way is counting as tasks against my quota and should not.Am I missing something?Regards, 

8
R
1 year ago
A
Abbie SmithNew
asked in Troubleshooting

TeamUp doesn't have any option to log in and authorize the account

Hi, I’m new to Zapier and was wondering why I can’t seem to be able to connect my TeamUp account. I’ve connected other apps with no problems but TeamUp gives me no option to log in and clicking ‘authorize’ just makes ‘this field is required’ pop up, but there’s no field to fill in! Any help would be appreciated, thanks :)  

1
R
1 year ago
B
Blake SuddathNew
asked in Troubleshooting

Flodesk sign-in issue - Missing 'Redirect_uri' parameter

Good morning! I’ve been trying to sign into flodesk on Zapier. I know my login credentials are correct but have been receiving the ‘redirect uri’ error. I saw this in an earlier post back in FEB, it said bug was fixed. Any ideas?

1
R
1 year ago
D
Dustin VerBeekNew
asked in Troubleshooting

Error: Failed to create a prospect in Pardot Could not create prospect: Invalid prospect email address. Error code: 4

Hello Zapier Community,We are using Zapier for LinkedIn Lead Ads and are running into an issue with Pardot not recognizing our custom “work email” field in the Zap workflow. Our Zap produces the following error.Failed to create a prospect in PardotCould not create prospect: Invalid prospect email address. Error code: 4 Anyone run into this issue? 

2
R
1 year ago
P
phorionBeginner
asked in How Do I

What is best way to process large CSV files

I have CSV files with between 300,000 and 600,000 records, what is the  most efficient way -or what is the recommended way to process these files?  I should mention I would prefer to have them processed after they are received at a predefined mailbox

5
R
1 year ago
M
murphycaBeginner
asked in Troubleshooting

Authentication error: Reconnect your Drupal account to Zapier and enter a username/password that has an "Administrator" role in Drupal.

Hello, I have a new Drupal 8 with JSON:API enabled plus admin role. I have tried to connect many times with admin role. DOes Drupal work with Zapier? authentication failed: The username/password entered does not have access to this site. Please reconnect your Drupal account to Zapier and enter a username/password that has an "Administrator" role in Drupal.

2
M
1 year ago
L
ladanyibutorNew
asked in Code & Webhooks

POST request failed on Zapier but not on POSTMAN

Hello, when i got an email in gmail with an attachment contains XML (with my shopify order details) i want to send that XML to a hungarian invoicing system to make the invoice automatically. It took me some time but i managed to make the xml to work in POSTMAN, but i just can’t make it work in Zapier.Its the same file in the mail and in the postman.I tried attaching the file where the files should be attached, but the invoicing system didnt accept it, i think because it couldnt read it’s name.Few things might be important to mention:1.: I am not sure the cookies are fine, but i dont think thats the problem2.: The invoicing system API documentation say this: The request must be “multiform/form-data” type and must contain one file with the name action-xmlagentxmlfileIf someone want to read more about it , its here: https://docs.szamlazz.hu/#post-requestI attached photos so you can see what i did in postman and what i did in zapier. Thank you for your help!  

2
jesse
1 year ago
D
digitalazureNew
asked in Troubleshooting

WPForms hidden values not available in Zap module entry fields

We currently have UTM parameters captured in WPforms using hidden value fields. The fields populate fine and show in the entries on the website. However, when connecting the module in Zap to pass to ZohoCRM, all fields show except for the hidden fields. Anyone else have this issue and how did you resolve?

2
jesse
1 year ago
D
Daniel BenchimolBeginner
asked in Troubleshooting

Some of my labeled Gmail emails aren't being imported into Google Sheets

I´m trying to use Zappier to extract the information of some emails into a Google Spreadsheet. The idea is to import all data (date, recipient email, subjet, text) from the emails that have one specific LABEL into GMAIL. But it is not working well (some emails are imported and some aren´t).

4
rachael.silvano
1 year ago
L
Lyndsey MurphyNew
asked in How Do I

How do I push the information we receive from Google Sheets in two different directions?

Hi! We are trying to push the information that we are receiving in Google sheets two different directions. (If they say yes I want them to go into one group in Agency elephant, if they say no I want them to be zapped into another)

2
rachael.silvano
1 year ago
M
MayanneNew
asked in How Do I

How can I ensure only labeled emails will be forwarded to the email parser?

I tried the email parser and forward specific email label only but all emails are being forwarded. How to ensure one the selected label will be forwarded?

8
rachael.silvano
1 year ago
M
Mike ShoreBeginner
asked in How Do I

Custom Salesforce Field unavailable in Zap

I have a zap from Salesforce to TalentLMS (a learning platform) where I am sending an outbound message with a number of fields.  I added a new custom field to what is zapped over (in the outbound message), but when I go to the zap in the setup action step, I’m unable to find that field.  It has been a week since I added the field in SF, so don’t think it is an issue of a lag.  And other SF custom fields are being ported over successfully to TalentLMS.  Any ideas what I’ve done wrong or where I should be looking?  Thanks!

8
rachael.silvano
1 year ago
K
kaushalkachiyaBeginner
asked in Code & Webhooks

Want to check possibility of implementing workflow.

We are working on one marketplace. Lets call it www.xyz.com.Marketplace have lots of sellers who work on services like SEO or Designing etc.. and it has buyers who purchase those services.  There are sellers who are well knows and working on many services with the help of their own team. To make their life easy, We want to provide them with integration of Asana, Slack and many more things that can help them to organize and scale better.  As per my basic understanding, If seller create a webhook in his zapier account and provider xyz.com with webhook url to hit on specific action, We can implement this feature but I think the flow will be more tedious for seller and all of them might not be able to configure zapier easily.  I want a solution where each seller don’t have to create webhooks of own their own but as an owner of xyz.com I can give them some way that they can configure things in xyz.com and do the integration of their slack and asana from xyz.com. Is there a way possible for

4
K
1 year ago
A
anthNew
asked in How Do I

Upload File in Google Drive from Salesforce

How can I upload a File from Salesforce to Google Drive A file to be uploaded. Can be an actual file or a public URL.How can I specific the actual file from content document object? 

1
Danvers
1 year ago
Terms & Conditions