Skip to main content

Home
Get Help

Get Help

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

28114 Topics

Most views

Recently active Most replies Newest first

CCDNBBeginner

asked in How Do I

How do I create a Zapier workflow that updates my Mailchimp list, assigning a unique word to a Merge field

I've been trying to sort this out for two days now...I have a random password and QR Code I need to assign to my subscribers Merge Fields. I've asked Chat GPT and this is how far I can get.I'm hoping for some help. Here is a breakdown of my workflow. I’m not committed to it and will change it if necessary.Can someone please help me out? Trigger: Scheduled Campaign in Mailchimp(WORKING) Action 1: Code Step - Generate Random Word Add a "Code" step in Zapier after the trigger. Use the following code to generate a random word: CODE (WORKING) Action 2: Code Step - Generate QR Code Add another "Code" step in Zapier after the "Generate Random Word" step. Use the following code to generate a QR code based on the random word: CODE (NOT WORKING) Action 3: Retrieve Subscribers Add a "Code" step to retrieve the list of subscribers from Mailchimp. Use the following code to make an API call and retrieve the list of subscribers: CODE (NOT WORKING) Loop: Iterate through Subscribers Add a "Loop"

blocktecBeginner

asked in Troubleshooting

Failed to create a create lead/opportunity in Odoo ERP Self Hosted

Fault (code operator does not exist: integer = boolean LINE 1: SELECT COALESCE(password, '') FROM res_users WHERE id=false ^ HINT: No operator matches the given name and argument types. You might need to add explicit type casts. ) occurred. Message: Traceback (most recent call last): File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 60, in xmlrpc_1 response = self._xmlrpc(service) File "/opt/odoo12/odoo/odoo/addons/base/controllers/rpc.py", line 49, in _xmlrpc result = dispatch_rpc(service, method, params) File "/opt/odoo12/odoo/odoo/http.py", line 120, in dispatch_rpc result = dispatch(method, params) File "/opt/odoo12/odoo/odoo/service/model.py", line 36, in dispatch security.check(db,uid,passwd) File "/opt/odoo12/odoo/odoo/service/security.py", line 16, in check return res_users.check(db, uid, passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_users.py", line 663, in check self._check_credentials(passwd) File "/opt/odoo12/odoo/odoo/addons/base/models/res_user

craigduerdenBeginner

asked in How Do I

Google Sheet New Row export as single line CSV

Hi,I currently upload data to a Google Sheet (very simple data “First Name, Last Name, and Telephone”). Every time someone submits our webform the row is added to the Google Sheet.I would like to know how to pull the data from that new row into a CSV file for me to then send to an email address. Please note, the CSV should not include the column headers (First Name, Last Name, and Telephone), just the values (Joe, Bloggs, 0777….).Any help or advice is greatly appreciated.ThanksCraig

grmdocumentmanagementNew

posted in Code & Webhooks

Webhook action - API pagination token with loop

Pardot API returns a next page token when number of items in response is bigger than the limit. I was looking for a way to iterate responses in a way that will use the new “next page token” on each loop iteration.The solution: calculated delay, delay, retrieve token, api call, store token.This is how i did it.Before the loop:Run first iteration of api call and actions after. Store the refresh token in storageThe way i resolved it is by using delay, storage and some math.loop iteration through the max amount of iterations need, you can calculate it if you have access to the db. Calculate with formatter how much the delay should be (how much one request takes + a bit more). i had to slow it down to 5 iterations per minute. Retrieve the token stored At this point i added a filter to make sure i got the value and right after removed the value in order to make sure i don’t repeat the same iteration twice. this caused me to slow the delay to 4 per minute. Delay action by the part of the minu

jweroenBeginner

asked in How Do I

How do I send picklist values instead of IDs to Mailchimp?

how can i send the picklist value instead of the id to mailchimp

PatrickDBeginner

asked in Code & Webhooks

Connection to Jira Service Management API

Hey Team,Having a heck of a time getting a successful result from a connection attempt to our instance of Jira Service Management. I have followed the API documentation I think to a “T,” but need a bit of a push if anyone has implemented this before.The ultimate goal is to eventually create new Organizations after they show up in another internal system, but during my troubleshooting, I am scaling back and just trying to get a successful result by using GET Organizations. Here is the setup: After this step, I provide my Jira credentials and successfully connect. Here is the error:The only odd thing I found is in the API doco, it also shows an additional HTTP Header of “Authorization: Bearer <API Token.” I originally did not add this since my assumption was since I could successfully connect using my credentials, along with the note of “Authentication headers are included automatically,” this was not needed. However, I did generate a token and added this header, but it resulted

erin_vulpeculaBeginner

asked in How Do I

How do I extract an email address from the body and use it as a recipient email?

Hello! Is there a way for me to extract an email address from the email’s body, and use that email as a recipient? To explain this further, I use Kajabi for my courses, and I receive an automated notification email whenever a new student enrolls. Now, I want to setup Zapier to send an automated email to the new student after a certain period of time to ask them a few questions. The thing is, I’ve done this with Teachable because their notification email includes the customer’s email as a “reply-to”. That’s why I was able to set that up in Zapier. However, the reply-to email address for Kajabi is set up to be directed to Kajabi's email. I’ve talked to a Kajabi representative, and they said that they don’t have the feature like in Teachable, and I have to manually edit or input the customer’s email to the reply-to email in Kajabi, but that’s a lot of work. So I’m wondering if I could extract the email address from that body because the notification email includes the customer’s address

qusNew

asked in Troubleshooting

We hit an error adding your new account authentication failed

We hit an error adding your new account authentication failed: Your API Key is invalid. Please try again.

asked in How Do I

Change the status order (paid-Unpaid-Returned) on Shopify

Hi I use Cash on Delivery (COD) on my store in Shopify I want to learn me how can I use Zapier to update the orders from (Unpaid to Paid). Also I want to change the undelivered orders to (Returned) I get excel sheet every 2 weeks from the shipping company and you know that the change it manually it will be so hard

A

Anonymous

asked in Code & Webhooks

How do I add a prospect as a new contact in PipeDrive from Expandi, personalize the email message, and update Apollo?

So I’m looking for a way to automate some of the repetitive tasks I find myself doing each week, but before I bite the bullet and sign up, I wanted to ask the community if I understand Zapier correctly.I’m using Expandi as a LinkedIn outreach tool, Pipedrive as a CRM, Apollo for email sequences and G-Suite for productivity.When I make a new connection using Expandi, I plan to tag them. That tag will act as a trigger for the following actions:Prospect is added as new contact in Pipedrive (after checking if already exists) Details are enriched in Apollo with work email address and/or phone number Personalised outreach email sent with ‘thanks for connecting message’ Prospect added to sequence in ApolloIf all these are straightforward enough, then a simple “yes, all these are possible in Zapier” reply would be appreciated! I’ll cross the bridge of how exactly to set it up in due course, but any relevant links to tutorials would be appreciated! Thanks

asked in How Do I

Zoho CRM: Unable to create entry in module - Error: Invalid data for the field Total_Distance

Hello,I set up a zap between Firebase and Zoho CRM.In order for some fields to work with Zoho, I have to truncate them - as Zoho has a 9-number limit. This step seems to work just fine. However, when I use that value, I keep getting the following error message: I checked in Zoho that the field actually accepts numbers. What am I missing?Thank you!-Aurélien

asked in How Do I

Zap to create payment and send receipt in Zoho Invoice

I do bookwork for a charity, and we receive tax-deductible donations. We use Reckon One for bookkeeping, and Zoho Invoice to issue donation receipts, as there is no receipt function in Reckon One. I have set up a Zap to create a new invoice in Zoho Invoice when a Receive Money to our gift fund account is created in Reckon One. This works fine. What I am now trying to do is continue that zap to automatically mark that invoice as paid and send a payment receipt, if the item name is Donation. The only action events I have for Zoho Invoice are Create Contact Person, Create Contact, or Create Invoice. Nothing to create a payment, or even update an invoice. So I’m guessing I’ll need to use webhooks or something similar, but I can’t seem to get my head around them. Is anyone able to help?

amlfitco developerNew

asked in How Do I

Issue with Okta Account Creation Zapier - ‘alternate id’ appears instead of actual value

Hi friends,I have an Okta Zap set up to make a Trainerize account when an Okta account is created.I can see the user email under ‘alternade.id’, but when it goes off and sends it to Trainerize, it just shows ‘alternate id’ instead of the actual value.https://cdn.zapier.com/storage/photos/00f986ec05b113267f3099d070e141f7_3.pngWould love some support on this.Side note, I wish there was a way to specify which group i assign a user to on the Okta assign user group event, instead of only being able to track any user being added to a group

youngotooBeginner

asked in How Do I

post multiple photos on Instagram

I want to upload multiple photos to Instagram.Is this possible?I know you said no, 2 years ago, but I was wondering if it's possible now?I have Google Drive and Instagram integrated, but I can't select multiple files in the Instagram zap?

VaradigmBeginner

asked in How Do I

How to split up form values all contained in one field

How can I extract values and put them in their own fields?As you can see above, some form fields (your name, your email and best number to call) were all joined together and sent in “Task Description” field that the zap sees. I need to use the values (Mary Smith, mary@xyz.com)How can I split them into their own?

JojinBeginner

asked in How Do I

How to silence a zap for certain time while resuming actions?

Here my zap needs to be silenced for lets say 15minsThe action trigger is “new post in a private channel” for slack.After the trigger gets initiated, the tricky part is not to get triggered for any messages in slack for the next 15 minutes while at the same time need to run my action steps without any hindrance.Any possible workaround on this? please let me know

asked in Troubleshooting

Unable to find shared folders in Box

Hi, everyone, I’m hoping I’m just missing something obvious, but “find a folder in Box” isn’t working for me.Here’s what I have in Box. And here’s the Zap: the zap returns that nothing is found. I’m at my wit’s end on this.

Bot TestingBeginner

asked in Troubleshooting

Failed to create a group contact in Google Contacts: Resource name is not a valid contact person resource.

I am trying to make a bot which will look at a new input in google sheets and create a new contact. It will also label or in its terms it would add the contact to an existing group. It always shows an error when I try it. It shows that the contact wasn’t able to be found. I tried the id, name etc and also looked at this https://community.zapier.com/how-do-i-3/we-had-trouble-sending-your-test-through-1146 but it didnt help. Please help!!

AppGuyAaronBeginner

asked in How Do I

Handling Customer Logins

So I have been doing side work helping people with automation as I work to launch my automations agency- mostly through Fiverr gigs. One thing that bugs / concerns me is that there is no great way for customers too small to use Teams accounts to invite in a consultant to do zap work for them without giving the consultant their password (which is sometimes their Google login). I always ask customers to change their password to a temporary one, but I feel like maybe 1 in 10 actually do that. Has any Zapier experts or consultants come across a good tool that will allow you to ask a customer to safely input a password so that you can use it… but cannot actually see it? Something like LastPass or 1Password but as a go between for consultants and clients? Especially good if its a tool already integrated with Zapier and could be used in an onboarding workflow!`A

asked in How Do I

Vimeo - upload to folder

Hello, I am trying to upload a video from Zoom to Vimeo, but to a specific folder. We got several videos per day and i don’t want them to pollute Vimeo main view, I have a separate folders for them. I haven’t seen that option in the Vimeo actions, nor i have an other idea how to achieve this… Anybody? Thanks!

pmiddletonBeginner

asked in Troubleshooting

Resolving .txt file upload issue instead of .wav/.mp3 files when downloading from Dropbox link

Hi,I work for a music producer and I sort through the loops/samples they get sent in their gmail inbox. I want to make a Zap whichdetects a new email with a dropbox link in it Downloads audio from link (usually a folder containing audio) Uploads audio to a specified folder (folder name from dropbox should be folder name in specified folder)I currently have step 1 and 3 working but every time it uploads a .txt file. Majority of files are .wav or .mp3.Im using a domain name gmail so I have no restrictions

majidBeginner

asked in How Do I

send email to client from asana when task complete

Hi, how can I send email from asana to direct client when task complete. and I have already tried to connect asana+ gmail but this is not working because I am confusing to select option “to”. Now please anyone help me for whole the process. I want just send email to client directly from asana.

asked in How Do I

Manychat: find a user and modify his custom field

Dear Zapiers, I’m new to Zapier, still look through community and didn’t find the answer for the following issue. The task. First APP - Manychat: 1. In Manychat I have a list of user, who have custom FIELD A - “user_email” with emails entered there; 2. All these users have custom FIELD B - “order number” which is not filled yet. Second app: Fondy (payment service, where I have merchant account and manage customer orders). 1. When customer pays, he put his email in into a customer FIELD C: “sender_email”. 2. When payment is done it order id is set to it. What I want is when someone makes payment, Zappier found a User in Manychat by comparing FIELD A and FIELD C and modify FIELD B of this user with ORDER ID. I successfully created a Zap, where triggers is tested and working (via Webhook). This Zap, can find a user by custom field. What should I do, to modify custom field value? Sincerely yours, Dmytro This post has been edited by a moderator to remove personal or private information.

asked in Code & Webhooks

Regex / Python code to select all characters except some specials

Hello friends, I try for a long time to use a Regex pattern to extract all characters from a sentence, except some special characters.Here is an example of the original sentence data :["https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File1.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File93.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File83.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File73.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File63.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File53.pdf","https:\/\/www.website.com\/sub_1\/sub_2\/sub_3\/sub_4\/sub_5\/sub_6\/File43.pdf"] My goal is to remove the characters [ ] \ and “ to keep only the url’s separeted by comma.I can do it in 4 steps (1st remove [, 2nd remove ], … but my entire zap will have more than 50 steps at the end !I tried this Python regex :import rere

asked in How Do I

Integration of LinkedIn with Odoo

When trying to link the linkedIn with odoo, the sample test worked in LinkedIn but when selecting To Do as Odoo and going to the custom Lead and pressing the "Refresh Field" it's throwing error "Zapier had trouble retrieving custom fields from Odoo CRM."Please help as i am new to Zapier.

1
...
330
331
332
333
334
335
336
...
1125

Page 333 / 1125

Powered by Gainsight

Terms & Conditions

Sign up

Already have an account? Login

Use your Zapier credentials

Log in with Zapier

Log in to the Community

Use your Zapier credentials

Log in with Zapier

Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.

Enter your e-mail address

Back to overview

Scanning file for viruses.

Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.

OK

This file cannot be downloaded

Sorry, our virus scanner detected that this file isn't safe to download.

OK