Find answers to your questions. Ask the Community for help or hire someone to help you.
MYSQL lines to a certain sheet in google sheets based on variable.
Hello,Is it possible to send data to a specific sheet in a google spreadsheet based on a variable in the data SELECT(ed)? In the example below would it be possible have the zap place the data in a sheet based on what order_extra_val_4 is. For example: if order_extra_val_4=Session_1 the zap would either place the data in the sheet labeled Game_1 or would create a sheet named Game_1 and place the data in that sheet? On top of that would it be possible to make the 'Friday Session 1: Level 5 Junior A & B Senior A' dynamic? Right now I am having to create as many zaps as there is sessions(sheets) and changing the code based on the session(ms_orders.order_extra_val_4 = 'Friday Session 1: Level 5 Junior A & B Senior A') SELECT order_id, order_extra_val_1, order_extra_val_2, order_extra_val_3, order_extra_val_4, order_extra_val_5, order_notes, order_total FROM ms_orders LEFT OUTER JOIN ms_cartON ms_orders.order_id = ms_cart.cart_orderWHERE ms_cart.cart_pic_date_org = '2021 Level 3-
OneDrive Find File is not finding the file
Hi I am having trouble with the One Drive integration when its trying to find a file. Even though I can actually see and open then file in my one drive, the find action will not return the file. The file name to search for is coming from a previous step so i know it is being typed correctly. The strange thing is when I and edit the step and run the test, it eventually finds the file after several times Does anyone know if I am doing something wrong or how to stop it from happening I have even tried putting a delay in for 5 mins to see if it was an issue with the file uploading
Webhook POST for Google form response submission
I am trying to a create a zap to push the responses of Microsoft forms to Google form through the POST method of Webhook.So the trigger is on Microsoft excel for web in which all the responses are stored in real-time. And then the Action has to be Google form response submission. I have another script linked in the Google form which will be triggered only when the Form is submitted. And the Zapier Action for this does not actually submit the form response but rather directly adds the response as a new row in the response sheet.So I thought so trying out webhook to do achieve this, but sadly I don't know how to use Webhooks. I found a solution online where I can automatically submit a form response with the help of a prefilled URL:Eg: https://docs.google.com/forms/d/e/1FAIpQLSdDCmmHjGT8NlztYek5Tfr9_BYysakwg7l-fIawCSf2IDLu2g/formResponsefirstname.lastname@example.org&entry.1434046471=Task+ID-100&entry.1039880062=Approved&entry.1725448845=No+comments&s
Formatting Text Filename- Find and Trim Trigger Word with Multiple Possible Trigger Words
Hello friends! I’m struggling with what I feel like should be pretty obvious but I keep hitting a wall. See below for a breakdown of the issue: So basically, we have a bunch of digital assets with a standard filenaming convention. It goes Type_AssetName_Stage_Artist_Version, where Stage could be Rough, Clean or Color. For example:PR_Shovel_Rough_Bob_v01CH_Fancy_Lady_Clean_Joe_v03BG_Ext_Dentist_Office_Color_Karen_v02 I want to make a Formatter step that takes these filenames, whatever they are, and trim off the _Stage and everything after it. So PR_Shovel_Rough_Bob_v01 would become PR_Shovel, CH_Fancy_Lady_Clean_Joe_v03 > CH_Fancy_Lady, BG_Ext_Dentist_Office_Color_Karen_v02 > BG_Ext_Dentist_Office_Color I know how to do this using formula functions in either Google Sheets or Airtable. My formula finds either ‘_rough’, ‘_clean’ or ‘_color’ then trims it and everything after using FIND and MID. However, Zapier doesn’t seem to have the functions I need under Formatter > Numbers &g
Wordpress form -> send email with information to gmail inbox
Hi! I’m very new to both zapier and wordpress, so hopefully some of you guys will know this! We just launched a new website on wordpress and our website we have a lot of forms - e.g. purchase form, apply for scholarship and so on. Before we went live with the new website every time I tested the forms I got an email with the information from the form in my inbox. However after we went live with the website (and changed hosting) we don't receive emails. Is there any way I get set up zapier so when a form is sent in, it zaps and I receive the information from the form in an email? Or in a google sheet maybe? Both are great solutions! In the near future we want to change our newsletter service to Active Campaign so if it is not possible to zap to either Gmail or a google sheet an alternative is AC.Hope to find an answer soon :-) Thank you in advance! Kind regardsKathe
Converting url into a PDF in Airtable
I am trying to create a zap that will convert a url into a pdf that can be stored in Airtable. The first zap is using Docusign to connect to our Airtable base which generates a url of asigned Letter of Agreement from Docusign. We now need to be able to take the url that is generated and convert it into the pdf to store in the same Airtable base. Is this possible?
Is Zapier - or IPAAS - a good fit for my use case
Hi,I have some micro-services and servers that will generate events, and I want to ping other services as a result.My default is to reach for EBS (RabbitMQ for example) to handle the job: service A drops a message on the bus, Service B picks it up.However, unlike previous engagements, I’m dealing with a small on-prem stack and a lot of SaaS providers.Is Zapier - or IPAAS - a good fit? Use CasesNotification of event $x from a service A to service B. Creating an issue in gitlab on alert of an issue in deployment. Create a ticket in customer ticket system on alert of an issue with account or process. Thank you in advance for your time. bdunbar
Monday.com to Aweber
Hi So I am sending leads from Facebook Leads Ads to Monday.com using Zapier. Once that item is created in a board in Zapier I want to send the lead info to Aweber so it send automated welcome email series. Having trouble as I can’t find the column values to send name and email to Aweber to create a new subscriber. I have tried everything and it’s bugging me. Please help! Thanks in advance
Customize Zapier button in shopify
Hey all, I’ve noticed this Zapier button within my Shopify orders - the button is set to “add new paid orders to a spreadsheet” - I am wondering if it’s possible to configure this button to trigger other Zaps? Specifically I would like it to send an email with the order information to my manufacturer. I could create a zap that would just go ahead and send that email whenever a new paid order is made in Shopify, however, I like the idea of being able to review the order and send it when everything looks fine. If not - are there other ways to trigger a Zap “manually” from within a Shopify order? Hope someone can help :-)) All the best,Philip
Formatting Shopify orders in Trello (Cards)
Hi, I am trying to add new shopify orders as cards in trello. I am interested in formatting each line order in a separate line in the card description. So far I have managed to transfer the data as one chunk of text - however, for a better overview I need each line order in a separate line. Hope someone can help with this!/Philip
IMAP Mail Attachment to Lexoffice
Hi,I’m trying a simple upload from a mail attachment to lexoffice. IMAP E-Mail is setup and working.In Lexoffice I have to select a Filename with extension and the file itself.IMAP E-Mail just gives me “1. Attachments: (Exists but not shown)”, without a filename or extension.I tried to use *.pdf for filename with extension and the predefined attachements for file, but this doesn’t work.Where is my issue?The mail only have one attachement (invoice in pdf style).
Help with Gmail and amoCRM integration
Я не понимаю, как вывести имя и номер отправителя из темы письма в отдельное поле в amoCRM. Кто знает, скажите, пожалуйста. Извините за мою речь, но я пишу через переводчика. Translated to English:I don't understand how to output the name and number of the sender from the subject line into a separate field in amoCRM.Who knows, please tell me.Sorry for my speech, but I am writing through a translator.
How get Google to send repeating calendar invite to Attendee?
Adding a person to existing monthly meeting on Google Calendar, using Zapier, but when the client gets the invite from Gmail and clicks "accept" it only shows up for the current month -- not all the future months, so only the current month is showing up on their calendar -- any idea why? Any suggested workarounds?Thank you in advance for your help. Some brilliant people on this forum.
Shopify Line Item Support On Creating Order (Multiple Products)
Hi there, This is a bit of a different use case. We have a form that customers can use if they need replacement products. They can select multiple products and these are brought into Zapier as line items. The problem is that the “Create Order” function in Zapier for Shopify ONLY allows you to select one Shopify product. If you choose “Custom” and put the line items in, they’ll push to Shopify, but as new, unlinked products. I need them to come to Shopify linked to the products that already exist in Shopify to accurately decrement stock levels, etc. I can't figure out how for the life of me to do this. I have ensured that the names match what Shopify is expected to see. I did a lookup table for the ID that Shopify is expecting and put those in a line item, etc. to no avail. You can see in the picture below of what I mean. The closest I’ve gotten is the highlighted “fake products” on the left which aren’t linked to anything. The circled product on the right is how it SHOULD appear. Any t
Calendly to Zoho CRM
I am trying to have a new SPECIFIC calendly event scheduled sync up with a Zoho CRM lead using an account number reference and update a date field with the date the scheduled event was made. I have tried several ways and keep hitting dead ends. Anyone have any experience in this?Or at least how to update a field in Zoho CRM from a specific outside source like Calendly or any other app for that matter. If needed I can get Calendly connect to another app like Google Sheets and then go to Zoho CRM or whatever… I just need this to work.
Zap to delete file attachment in QuickBase
Hello,Is it possible to create a zap step that will delete a file attachment that is part of a record in QuickBase? Note that I do not want to delete the entire record. I merely want to automate the deletion of the attachment that was uploaded to a File Attachment field for the record when the attachment is no longer needed.Here’s what I’ve tried (unsuccessfully) in my Quick Base Record Update step so far:Leaving the file attachment field blank (nothing happens). Setting the file attachment field to “” (this just replaces the existing attachment with a new attachment of type .txt). Setting the file attachment field to [the value in another file attachment field that is blank] (nothing happens).Any suggestions?Thanks in advance!OJ
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.