Find answers to your questions. Ask the Community for help or hire someone to help you.
Missing data in sample row from Google Sheets
I am looking into creating an integration: when there is a new data in Google Sheet like the one below, it will be added or updated on MailChimp.However, when I am creating a trigger on the Google Sheet, I am confused why it says Spreadsheet Row A, Spreadsheet Row B, and Spreadsheet Row C. Isn’t it supposed to be Row Number? The first row of the Google Sheet is for the information column (First Name, Last Name, etc). Also, on the Google Sheet trigger no data is being displayed.Trigger - Google Sheet On the MailChimp action, I am getting a “Subscriber Email empty (required)” when I have data in the Google Sheet.Action - MailChimp
New Integration About Shopee Ecommerce / Shopee OpenAPI
Hello guys,I have submitted the Support Email to the Zapier and while waiting support response, wanted to post my query here regarding the Shopee Ecommerce Platform integration or Shopee OpenAPI integration.Can I know is there anyone is also the seller in Shopee? Cause what I want is to get those tracking number, order ID, product variation, etc. By getting those data, I will try to send message about the order detail to the customer who complete the order.This is the documentation of the Shopee OpenAPI for the developer, https://open.shopee.com/documents?module=63&type=2&id=56&version=1Here have some info about the Shopee Ecommerce Platfrom. Shopee is creating convenience for Greater Southeast Asians and is the leading e-commerce platform in Southeast Asia and Taiwan. It is a platform tailored for the region, providing customers with an easy, secure and fast online shopping experience through strong payment and logistical support. Reference from: https://my.wantedly.com/co
Sending an attachment with Gmail (from Jot Form)
I have a form in Jot Form.I have some values and an attachment in the form. When I test my zap I receive this error:The email could not be sent to Gmail.The app returned "Not Found". I cannot understand why.I have already followed this: https://zapier.com/help/doc/jotform-values-are-missing-or-incorrect Tks!
Dynamic account in gmail connection field
Hi there,I want to create a zap that tags users emails in gmail, triggered by an event in Knack, a database tool with users accounts. The twist is, Knack will have dozens of user accounts, and I want the zap to action for the user that is logged in to Knack - so instead of manually entering the user account connection for gmail, I want Zapier to pick up the user account from Knack - in other word, the user account connection for gmail is dynamic. Is that even possible? And how can I do it?
Systemo.io / AWeber Zap Only Working in Test Mode
Hello, i have exactly the same problem but with my zap for Systeme.io to AWeber. It’s for my newsletter registration. It correclty works in test mode, but when i do a “fake” registration on my optin page on SIO, nothing appear in zap history and nothing appear in new subscriber in AWeber… I tried with trigger “new optin” and “new tag is added” but it’s still the same…
How can I add time between multiple leads in same zap?
I run lead gen campaigns zapping form data to google sheets. I often have multiple leads come in before a zap runs. When the zap runs, that batch of leads is zapped all at once, which is breaking a google sheet add-on I’m using. Is there a way to space out the batch of leads within a single zap instance by 5 seconds or something?
One time bulk action possible: CSV to Teachable?
I have an existing csv file of approx 800 rows (user data...includes email addresses). I want to create a zap that auto-enrolls all those people in a Teachable course. I know how to use Zapier to add someone to Teachabel when a new row gets added to a spreadsheet (say a Google sheet), but can't figure out how to structure the zap do a 1 time bulk add with every row in that spreadsheet. Any ideas for me? Is this possible?
Shopify using a third party app + Google Drive
Hi,I'm looking for a company or a freelancer coder with Zapier skills to create an integration with my Shopify Store.I can't create by myself because I'm using a third-party Web-to-Print solution to generate pdf files inside my Shopify store.What this third-party app makes is provide a link to download pdf and jpg files created by the users. These links are available in the order page detail. See the screenshot.For each paid order, I need this Print Workflow:Create a Google Drive Folder with order info name Copy the JPG's to the created folder Copy the PDF to the created folder Copy the invoice created by a third-party Shopify app (Simplio) to the created folder Copy the print packing slip created by a third-party Shopify app (Not decided yet) to the created folder Update a Google spreadsheet about the orders and fulfilment Send a confirmation email to the production team start the job After finishing the job, Google spreadsheets need to be updated manually, and Shopify needs to get t
Field Integration Issues - Modern Events Calendar w/Constant Contact
I created a zap that --almost-- works perfectly. But…Custom fields I create with the Modern Events Calendar (MEC) plugin aren’t available to push to Constant Contact (CC)Custom fields I create in CC aren’t available as target zap options.MEC uses a NAME structure and CC uses FIRST NAME / MIDDLE / LAST NAMESo the best I can do is a hack - mush NAME incorrectly into something like MIDDLE and BOOKING EVENT TITLE into another random field like PREFIX NAME. Hence I’ll have to clean up the data later, making the zap kind of pointless.The goal being that users that register for an event in MEC populate either a particular list or can be segmented later in CC. So minimum success (above a hack) would be populating MEC’s EVENT TITLE into a custom field in CC.MEC does provide hooks (https://webnus.net/dox/modern-events-calendar/mec-hooks/) so there may be a plugin customization that works outside zapier?grateful for any insights!
How to select column values from Monday.com in Linkedin step?
hi all, I am trying to set an integration between monday.com and linkedin to post through a zap on our company profile, I have setup the post itself on monday in a board - each post has its own row and setup a trigger if a status changes, then to trigger the post (so we schedule the posts automatically to go). But I cannot figure out how to tell zapier where to take the content from (the specific columns). Is there anyone who knows how to do it? Here are the pictures of what columns i want to use: Post Content, Preview / URL, picture, title - and the trigger is if column publish changes.. However I do not see those columns as options in the setup - am I doing something wrong? thanks for your help! Kristina
Is it possible to extract part of an email to send it by SMS?
I am receiving an alert by email with big text, and I want to send only part of that text by SMS to a contact list by ClickSend and I would like to know if I am able to extrant only part of the original email to be re send because it is costing a lot if I re send all original message. Any ideas?Thank you!
Woocommerce and Copper via Zapier: Error 422
Hello,We are trying to automatically communicate Woocommerce and Copper via Zapier.We have already set up some parameters, tags and custom fields as dropdown format in Copper that our zaps don't seem to convert properly.We want to fill a dropdown currency parameter on Copper consisting of EUR, USD, GBP or AUD. Woo-commerce sends this information via the tag “Currency”, which is exactly EUR, USD, GBP, AUD. When we try to link the Copper parameter with the woocommerce export field, we get the 422 trouble error. This doesn’t happen if, instead of filling a dropdown parameter, we fill a plain text field. It is important for us to filter the currencies with a parameter, not a string.Any suggestion? Many thanks!
Zap Triggers on New Excel Dropbox workbook -- need to trigger on updated workbook
I have a Zap that triggers Formstack actions when a new Excel workbook is created in Dropbox. I need to either:(1) figure out how to delete the workbook after the Zap is complete -- I don’t see an action option to do that either in Dropbox or in Excel(2) ask the Zap to trigger on an updated/modified workbook rather than a created one. Has anyone else tried to do this? I currently have to manually delete the file before I trigger the zap.
PDF File Data in Google Drive
I want to send a pdf document to a gdrive folder (or dropbox) to trigger a new row in a gsheet. The problem is the information that I want to flow into the new row is not found in the zap setup. Note: I have software to add pdf metadata which does not appear during Zap setup. I guess my question is there a way to embed a pdf file with data that will be usable in the Zap setup? Thank you in advance for any help.
Spotify to Radio.co integration error
HelloI am trying to set up a Zap so that when I add a new track in Spotify, the track is added to my Radio.co account but I receive an error each time. The Radio.co account is fully subscribed.I get the following error:Got 400 calling POST https://studio.radio.co/api/v1/zapier/stations, expected 2xx.Any ideas?Thanks.
Trigger zaps in an order
Hello,I wanted to know if it is possible to trigger different zaps in a specific order. Each Zap has a different trigger. Currently I have 3 different zaps. I would like the second one to be triggered after the first one, and the third one after the second one. I couldn't find the answer by searching the community. Thanks !
Eventbrite to Mailchimp - tag subscriber
I want to set up a zap for Eventbrite and Mailchimp. From what I can see, what I want to do is not possible but I’m hoping I’m missing something I have already setup a Mailchimp and Eventbrite integration where all Eventbrite registrants automatically get subscribed to Mailchimp. This is the zap I would like to have:New Eventbrite event registrant > Tag in Mailchimp that they registered for this event (Tag says something like: Event Name registrant) I want the tag to be different for every event in Eventbrite. From what I’m seeing the tag has to be the same no matter what event. Is this possible or is there a workaround?
How can integrate with third party apps
Hi,We want to leverage Zapier to integrate with third party application. We have a requirement to pass data to the below API, read result and then take action.https://www.acra.gov.sg/announcements/acra-api-mall Can someone help me understand if this would be possible and how to go about itThank you
Send delayed zap if no second row filled in Google Sheets?
I use Facebook Ads to get new leads for my gym client.I want to have a new lead submit 2 forms in sequence because the form they prefer misses out on a lot of leads.If the new lead gives name/phone Form #1 only, gym receptionist gets a text within 5 minutes to call new lead and schedule a time. If the new lead completes Form #1 and then schedules a time using Form #2, gym trainer gets a text about a new appointment... and gym receptionist doesn’t get a text. My gym client has the following Facebook Ads flow:Lead clicks FB Ad > ClickFunnels > Acuity Scheduling.Acuity’s flow is: Choose appointment time > Enter name/phone > SubmitOn submit, I have Zaps set up: Data > New Row in Google Sheets > Send SMS to my gym trainer. I’d like to make sure the gym gets the name/phone earlier in the sales funnel. I’m looking at this flow instead:Lead submits FB Lead Form with pre-filled name/phone > Submit.Submit takes them to ClickFunnels > Acuity Scheduling.Then, as before, Cho
Trigger freshdesk ticket from woocommerce order
Hi, I am new to woocommerce and zapier and fresdesk. I have a store via wordpress woocmmerce.My goal is to have this:User submits order in wordpress Order is auto created in woocommerce Woocommerce order triggers New ticket in Freshdesk - with the information from woocommerce ordersThank you!
How to transform a date-time input and out put a date equal to the first of the month
I am receiving data from a form (date/time format) and I need to transform that into a date equal to the first day of the date’s month so I can send to another system as the effective date of the transaction. In this systems transactions always have the effdt of the first of the month, regardless of the date of signup.For example:Input date: 2020-11-06 11:27:13I want to transform into: 2020-11-01 (the first day of November).Is this possible to do?
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.