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 Reading
All of our best learning resources can be found here.

Featured Articles Show & Tell AI Hub Zapier Apps 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.

17515 Topics

K
kpiercyBeginner
asked in How Do I

Insert/Query to/from "Always Encrypted" SQL columns

Hello,I am wondering if anyone has tried and been successful in inserting data to an AWS RDS server that contains columns that are Always Encrypted and on the inverse, querying data out of an Always Encrypted table and retrieving the unencrypted value for use elsewhere in the zap.

1
M
1 year ago
F
felixcarverNew
asked in Code & Webhooks

Help accessing nested JSON values from Webhook GET

I’m trying to build a Zap to integrate Airtable with Google Maps API Reverse Geocoding service. Everything works as expected until I try to extract the values passed back from the API.In summary, I pass a Lat / Long to the Google Maps API and it returns potential address matches. I want to extract just the first (most likely) address match and add it to the Airtable record.Below is an example of the full JSON response copied from the ‘Test action’ tab of the Webhook Step. You can see there are several addresses returned from the query.plus_codecompound_codeVHXV+4R San Francisco, Nayarit, Nayarit, Mexicoglobal_code75GPVHXV+4Rresults1address_components1long_name66short_name66types1street_number2long_nameNueva Galiciashort_nameNueva Galiciatypes1route3long_nameNayaritshort_nameNay.types1administrative_area_level_12political4long_nameMexicoshort_nameMXtypes1country2politicalformatted_addressNueva Galicia 66, Nayarit, Mexicogeometrylocationlat20.897784lng-105.4057536location_typeROOFTOPview

1
robschmidt
1 year ago
D
Daniel StillmanNew
asked in How Do I

Stripe and Podia to Quickbooks Online - Line item support

I’d love to get stripe and/or podia into Quickbooks online as payments. But it looks like QBO doesn’t support line-items. I don’t really know how to use the formatter, which is the secret key it seems. What strings does QBO need to make this happen? Does someone have an example of this done well that they can share?

1
robschmidt
1 year ago
B
Beulah82New
asked in How Do I

Connect Cognito Forms to Flutterwave or Paystack

I was trying to connect cognitoforms with flutterwave or paystack, but it was bringing out single entries, but I want it to connect with forms and all subsequent entries use the single connection for all transactions.Please I need guide or someone to help.Thanks.

1
Danvers
Community Manager
1 year ago
V
vertdevNew
asked in How Do I

Create or Update Lead in Marketo action not showing fields under Default Partition

I am in the process of documenting our Zap( Read CSV file from Webhook into Marketo) step for my development team. During this exercise I realized that the default partition is not showing Marketo fields, which will render creating or looking at existing field mappings impossible. This was working a day ago and for the past few days. Are you having trouble retrieving Marketo fields on your end. Clicking the refresh button yields nothing.  

1
M
1 year ago
J
JulienNew
asked in How Do I

Facebook duplicated event from ClickFunnels

Hello, i actually use the Facebook pixel, and now the API with zapier. The problem is duplicated event on my Facebook… how can I resolve this? 

1
M
1 year ago
D
Dennis8New
asked in How Do I

When exactly is the task reset done?

Hey,can I check what is the exact time when the tasks will be resetted? Currently I just see “in 2 days”. But is there some kind of “countdown” or something? Or is it 0 am on this day, if yes what timezone is used?Thank you!

1
Troy Tessalone
1 year ago
N
ninan99New
asked in How Do I

How to use customer information in Google Sheets and HubSpot to create invoices in Xero

I am new to Zapier I am trying to pull info customer info from Google Sheet and then create an invoice in Xero. Once Hubspot is set up then we will have to pull the customer and sales order info from Hubspot to Xero    

1
Troy Tessalone
1 year ago
C
christophNew
asked in How Do I

Upload a file added to a “Media & Files” property on Notion to iCloud

I would like to automate the upload of files added to a “Media & Files” property of existing pages in a Notion database to a folder on iCloud.It seems like the Notion integration as of now (beta) only supports triggers for new database items, so I guess I have to wait until updated database items are supported as well (which seems to be supported by automate.io already so I guess it will be possible on Notion soon). I could not find any integration with iCloud, only other cloud storage like Google Drive for example. Will iCloud be supported any time soon or would I have to switch to another storage provider?Can anyone think of an alternative that would have a similar outcome that already works?Thanks for your help!

1
Troy Tessalone
1 year ago
J
jvlaznyNew
asked in How Do I

Importing a CSV with a title row + header row

I have a Zap where I’m grabbing a CSV file attachment from Gmail and using Utilities and Formatter to add the rows from the CSV to a Google Sheet. The problem is that the structure of the CSV is unconventional, it has a title row AND a header row, which leads to the output being invalid. When I manually remove the first title row from the CSV before importing it, it works fine. What kind of step / setting could I add to make the Zap essentially ignore the first row and acknowledge the second as the header row?Here is what the first two rows of the CSV file look like:NPS Survey Response Report :,,,,,,,,,,,,,,,,MASSMAILID,Template Name,Opportunity Name,Sent By,Sent On,Sent To,First Opened,No. of Opens,No. of Clicks,Status,Record Name,Subject,Amount,Closing Date,Next Step,Pipeline,Stage***data starts here*** 

1
Troy Tessalone
1 year ago
G
G7DAPNew
asked in How Do I

Connecting to Facebook Lead Ads - error turning Zap on

Hey  I am trying to create a Zap between Facebook Lead form and google sheet. Everything works fine until  try to turn the zap on i get this message:  I then go to the apps and then connections to test but everything seems ok with the connection.  Has anybody else experienced this? 

1
Troy Tessalone
1 year ago
T
tocNew
asked in How Do I

Splitting full name info from FB Lead Ads to Kartra first name and last name fields

Hi,I need some advise on passing information from Facebook Ads onto our Kartra system. We are using FB Lead Ads form to capture lead info and on the FB forms the fields include email and full name. Currently Kartra name fields are separate i.e first name, middle name, and last name. Now we want to pass the information from FB to Kartra so that the full_name field does not populate the entire first_name field in our Kartra database. How can I set it up in Zapier or does Zapier has a way to separate the full_name info from Facebook and have it populate as separate fields so they go to Kartra under first name and last name separately?

1
Troy Tessalone
1 year ago
M
manumoggNew
asked in How Do I

New Entry in Typeform to Send Lead Event to Facebook Conversions

Hey guys I’d like to send a Lead event from a typeform (event occurs at the end when user clicks on submit) to my Facebook Ads business account. What I did :    And then I fill the Event Time + Event ID + Event source URL , set up customer information, TESTED the zap and Zapier tells me it’s okay ! But when going back to Facebook ads account, no event was found…  Help

1
Troy Tessalone
1 year ago
G
gr3ggNew
asked in How Do I

Update to Trello Custom Field to trigger Zap

HI !  I would like to trigger a zap when a Trello custom field is updated. Is it possible ? Can’t find this anywhere … ;(

1
Troy Tessalone
1 year ago
V
Verónica CasasNew
asked in How Do I

Task limit - Typeform Submission to update Mailchimp subscriber

Hi!I am using the integration ‘Update a Mailchimp subscriber when someone completes your typeform’ with a free plan account in Zapier.It doesn’t work that well, in Mailchimp I just see some of the contacts are updated, while in typeform there are many more. The contacts are like “held” in Zapier, I attach the screenshot.Does anyone know the reason? Is each entry a task? Isn’t that weird? Thanks in advance,   

1
Troy Tessalone
1 year ago
E
Eric MagersBeginner
asked in How Do I

Mapping two Gravity Forms fields to a single Google Sheets cell

We  have  a  gravity  form the  has  two address field sections , one  for  domestic and one for international address.  They  are  hidden  and  displayed  conditionally based on a  check box.  We like  to map  them to  the  same  set of  cells in a  gsheet. So for  example  city (domestic) and  city (international)  in gravity  forms  both  map to  city in gsheets So  far  been unable  to  get this  to  work. It appears  that the  domestic addres fields  get mapped, but the international ones  do not.  If we  remove  the  conditional  logic from the  gravity forms  so we  can fill in data  for  both  address sections, we  get only  the international address data-  Not both sets as we would  expect. Should  this  be  possible?  Before  we  spend any more time  testing  this.  If  so  any likely  gotchas? Thanks  

1
Troy Tessalone
1 year ago
W
wp-okNew
asked in How Do I

How to use serialized data co Create Coupon in WooCommerce?

Hello guys,I have a Zap that creates a Coupon in a WooCommerce website.I need a custom meta data, and luckily Zapier allows that.The problem is the format of the data.The field is serialized, so when I add the entry I need:a:1:{i:0;a:4:{s:10:"product_id";s:4:"2087";s:8:"quantity";s:1:"1";s:15:"discount_amount";s:3:"100";s:13:"discount_type";s:7:"percent";}} It turns into this in the database:s:136:"a:1:{i:0;a:4:{s:10:"product_id";s:4:"2087";s:8:"quantity";s:1:"1";s:15:"discount_amount";s:3:"100";s:13:"discount_type";s:7:"percent";}}"; It's considered a string and serialized again. I can't find the right format to use, anyone can help with that?  ThanksDaniele

1
M
1 year ago
L
Luke BBeginner
asked in How Do I

New Integration - iDeals Virtual Data Rooms

Can anyone tell me if an integration with iDeals Virtual Data Rooms is in the works and if not how I can get this started?Here is their site: https://www.idealsvdr.com/Any help would be appreciated.

1
Troy Tessalone
1 year ago
O
OxyscapistBeginner
asked in How Do I

Error with Zap when connecting to Bubble

Hi @kevineskandary - were you able to solve the problem? - I am getting a similar error while trying to connect Bubble. Post split from Zapier is “unable to load choices from JotForm

1
M
1 year ago
S
suzycreamcheeseNew
asked in How Do I

Email addresses from new Rows in Google Sheets not updating in monday.com

Hi, I’ve connected a Google Sheets on my team drive to Monday.com to have any new rows or updates to existing rows zapped to Monday. However, I’m adding emails to the Google Sheets, and they’re not being updated in Monday.com. Please advise. 

1
M
1 year ago
P
Pau RolonNew
asked in How Do I

Connecting to MySql 8 Digital Ocean database - Bad handshake error

I’m trying to create a connection to my database from Digital Ocean, using Mysql 8 version, everything is configured to give access to anyone to our database, ssl is disabled, bind address is set to *, firewall allows the zapier IP, but it keep failing with the error (pymysql.err.InternalError) (1043, 'Bad handshake'). I don’t know what else to try to be honest, need some help, thanks.

1
Troy Tessalone
1 year ago
T
tootsies19Beginner
asked in How Do I

Trello to Slack Zap - add only the latest Trello comment

I’m working on a Trello to Slack zap, where any updates to a card in Trello will push a Slack post. The issue I’m facing is I want to insert the most recent comment from the Trello card. The only option I can find is to insert all comments, which makes the Slack post super long and unnecessary. I just want to show the most recent comment on the card to show the latest update. 

1
T
1 year ago
C
coolguy007New
asked in How Do I

Office 365/Outlook Sending Duplicate Emails

I have an automatic email setup that gets triggered when a client signs a Practice Ignition proposal. Office 365 Outlook is supposed to send a message to my admin/onboarding team… but lately it’s sending 3 duplicate messages. Anyone else encountering this error and know how to fix it?

1
Troy Tessalone
1 year ago
S
spatialdevNew
asked in How Do I

Eventbrite to Google Calendar event - incorrect time

I have a zap set up that automatically takes new Eventbrite events and adds them to a Google Calendar. However every time a new Eventbrite event is scheduled, it ALWAYS gets put on my Google Calendar at 8:21pm on the day the Eventbrite event gets created (not the day its scheduled for).This is how the date/time field is set up in my Zap.Any help? 

1
Troy Tessalone
1 year ago
P
Parv.BarraiserNew
asked in How Do I

Dynamically set Google Sheet Spreadsheet and Worksheet custom values

I am using Google sheet for multiple partners, A column mentions the partner sheet id.I wish to trigger my master sheet in such a manner that a partner receives data relevant to them.while setting up the action, in spreedsheet field, I am passing a custom entry of the partner sheet id.The worksheet field throws an error “Unable to load choices”.How do I make the spreedsheet field dynamic?

1
M
1 year ago
Terms & Conditions