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.

28152 Topics

Recently active

Most replies Most views Newest first

Edmund LamBeginner

asked in How Do I

How to retrieve the value from a particular Google Sheet cell

I want to know whether the following scenario can be created in a zap. I cannot figure out how to create zap steps to perform #3-5 below:1. Check whether a given Google Drive's folder has a new Google Sheet.2. If none, the zap can end.3. If yes, open it and search whether cell C1 (always the same cell location although it is a different file each time) has a value.4. If C1 is empty, do nothing. Go to Step 6.5. If C1 is filled, copy it and paste it into cell D1 in another Google Sheet (it is always the same file).6. Once done, move the Google Sheet located in step 3 to another designated folder. Thank you,Edmund

markkoeksBeginner

asked in Troubleshooting

Are there a list of modifications for Apps that we know will cause a Zap that uses that App to stop working?

Recently I had two Zaps stop working and the teams losing data and confidence when updates to the Notion database were made. The Zap looks for a new line in Google Sheets, and creates a Notion database item. But when the database was updated to include two new columns/values that were not applicable to the Zap - it stopped working. I know for example that changing a field in Notion (title, type, etc) that the Zap updates will absolutely break it - but what about other modifications that are not part of the Zap?I’m using Google Sheets - will moving a Sheet from my account to a Team Drive break the Zap?Can I update the account in a Zap from my personal account to a “workflow” user account that is shared amongst multiple users?

Its Tech WorldNew

asked in How Do I

How do I connect Facebook leads to webhooks without trigger and automatically save data on the URL?

How do i connect my facebook leads to send on webhooks actively without any trigger automatically save data on post url in webhook

Campbell CreativeNew

asked in Troubleshooting

WooCommerce error: Returned "The username and/or password you supplied is incorrect.".

I continue to get this error while trying to connect my WooCommerce to Zapier. I have the purchased plug in, my cookies are good… I have recreated new code, everything. I just don’t understand. Help!

Thales CampolimNew

asked in Code & Webhooks

Replace null values with 0 in a array

I am collecting conversion data from facebook’s API, and grouping it by hour.As there isnt conversions for every single hour, it’s bringing a whole array of values comma separated, so as I want to put it in a google sheets, I need to input a value 0 for the hours I dont have any conversions. I tried to use the code this article suggest , however, I am no getting the same result as my output just remove the null values instead of replace it with 0.Input: Output:

asked in Troubleshooting

Notion error: Unsaved transaction, Unrecognized error.

Hi,Problem with two Zaps just started - one goes from Google Calendar to Notion and one from Todoist to Notion. So appears that Notion may be the issue? I receive a: Notion Unsaved transactions: Unrecognized error. message and nothing is transferring from the sending to the receiving app.Any idea what might be happening or how to fix it?Thanks in advance.

Impact2023Beginner

asked in Troubleshooting

Trouble authorizing Squarespace to Airtable due to "Grant Access" button issue.

Trying to create a new zap from a membership form in squarespace to a table in Airtable, The problem is that I’m asked to “Verify my email to authorise the integration”, but I can’t find a way to authorise it / grant access (see picture). I can’t push the “Grant access” button and I don’t get any email to confirm it. Can anyone help out? Thank you!

asked in Code & Webhooks

Zap to Slack integration is showing HTML tags

We are currently experiencing an issue with our Zap to Slack integration, and we need your assistance to resolve it.The problem we're encountering is that when we use the Zap to Slack integration to post content, it displays HTML tags instead of rendering the content correctly. This is affecting our ability to share information effectively within our Slack channels.Ideally, we would like our Slack posts to render correctly with images and formatted text, as they do when posted directly within Slack. However, currently, we are seeing raw HTML code in the posts.To provide you with more context, here are some additional details:The Zap is set up to trigger when specific events occur in the Beamer application. The content we are sending to Slack includes text, images, videos and links. We expect the content to display as it does when posted manually in Slack.We are unsure why this issue is occurring and would appreciate your guidance on how to resolve it. We want to ensure that our Zap to

deathandtaxesNew

asked in How Do I

Can I update a Billin quickbooks

Here is the scenario incase there is another way to solve this.All in quickbooks onlineThe client has a customer Invoice in Quickbooks and they also have a corresponding Vendor Bill in quickbooks.Payments are not made to Vendors until the corresponding Invoice is paid (both use the same number).But once a Customer pays the invoice, we need to update the Vendor Bill to indicate it is time to pay it.Currently this is done by hand, using a report of recent customer payments, looking at the invoice #, then looking a report of outstanding Bills and finding the Bill Numbers that match. Finally putting that list of Bills in a spreadsheet for management to review / pay.It would be easier if once the Invoice is paid, it updates a field on the corresponding Bill, so a report can be run for Bills with a value of X in that updated field.I see there is a trigger of a payment in quickbooks, but I don’t see where I can update a Bill.Hopefully this make sense.Sorry, I am new to exploring these automa

Queesntown ITBeginner

asked in Troubleshooting

Error creating SharePoint folder with Gravity Form submission attachments.

I am creating a zap wherein whenever there’s a new submission via gravity form, a sharepoint folder will be create consisted of all the attached documents in gravity form. However there’s an error saying it cannot create folder.

lcallanderBeginner

asked in Code & Webhooks

Send Facebook Lead to Leap JobProgress API via Webhook Post

After reading this community question, may you help me with this API post?Step TWO of my Zap: ProTech FB > Em > WhatConverts > BQ5Contains a Webhook with the token, headers and a couple sample data fields for testing.Getting a 412 error when I test the step, which may be related to the headers or authorization.Public API documentation is located here:https://docs.api.jobprogress.com/I’m using the POST - Create Prospect example. Here is how my webhook is created so far:URL: https://api.jobprogress.com/api/v3/prospectsPayload Type: jsonData: first_name = Donald last_name = Duck email = dduck1925@toon.inWrap request in Array: NoFile (none)Unflatten (default yes)Basic Auth = (actual username)|(actual password) <<=== with user/pass get 401 error; without get 412 errorHeaders: Content Type = aapplication/x-www-form-urlencoded Authorization = Bearer (copy/paste token) ~~ Looking forward to your feedback!

asked in How Do I

Using Chat GPT to identify missing info and sending an email

Hi team I am struggling with correct chatgpt zap I want to be able to read new emails, identify where there is missing info (eg an order quantity might be missing on a sales enquiry) and then reply asking for that info Any ideas?Thanks :)

cassiemacfarlaneNew

asked in Troubleshooting

Shopify & Flodesk zap not working

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.Hey hey! I’m having troubles with my zaps working in real time, integrating Shopify to Flodesk. I want the zap to send a customers email from a specific product purchase in Shopify and insert them into a segment inside Flodesk to send them targeted emails based off the specific product they purchased in Shopify. I set the Zap up and the tests ran fine, but as I was running tests in real-time, it looks like the zap is not working. I checked the segment inside Flodesk and there was no email added into the segment. Below I have screenshots of how I have the Zap set up, I wonder if the filter I’m using is correct? THANK YOU SO MUCH for your help in advance!!!! Screenshot #1: the trigger I have set up Screenshot #2: the filter I have set upScreenshot #3: the action I have set up

asked in Troubleshooting

My Zap isn't triggering to pass Manychat tag to CRM

Hi there,I set up a new zap that is supposed to use Manychat’s Instagram lead magnet automation to pass a contact to my CRM. The automation triggers when someone comments on an Instagram post with a keyword. Manychat is supposed to then add a tag to the user info, which gets passed via zapier to the CRM (Highlevel/Leadconnector), which in turn sees that tag, adds it to the user, and triggers delivery of the lead magnet (a free PDF ebook). For some reason, the tag is not passing through no matter what I do. I’ve tested the automation and it works. I’ve tested the Zap and get a success message. My Zapier history is showing that the zap is just never getting triggered. I’m not sure what I’m missing. Thanks in advance for any help! Screenshots below.The zap:The tag specified (it reads: “Instagram high interest rate lead magnet”The Manychat workflow step where the tag is added:The details on the step (red arrow above) where the tag is added:

kburtBeginner

asked in How Do I

Task Limit Reached Due to a Zapier backend error

I am writing to formally address a critical matter concerning our Zap limit, which has recently posed significant operational challenges.Our established Zap limit was meticulously set at 5000 tasks. However, due to an unforeseeable incident involving a particular contact, we have encountered a situation wherein tasks have been recurrently generated, surpassing the allocated limit by an approximate count exceeding 5300. Importantly, it is imperative to emphasize that this occurrence was not attributed to any actions or oversights on our part.The repercussions of this task limit infringement have been profound. Regrettably, it has severely hindered our capacity to seamlessly integrate our systems for our indispensable marketing campaigns. I have initiated a formal ticket with our dedicated representative, KJ, urgently seeking an increase in our task allocation. Although we appreciate that KJ has already provided an additional allotment of 3500 tasks, it is crucial to note that the origin

oliviasuneBeginner

asked in Troubleshooting

Issue with Typeform multiple choice fields not mapping correctly in Salesforce.

Hi Team, I’m using a pretty standard flow to create a lead in Salesforce when a new typeform has been filled out. I am having an issue with multiple choice fields from typeform mapping properly and appearing properly in Zapier to be able to map. Some fields (below) populate with all of the custom questions and answers, but some only come up as pre-filled options in Zapier, but come out in Salesforce selecting all options, not just one selected in the form. Has anyone experienced this or can point me in the right direction :) Picklist one - multiple choice, more than one option permitted, shows up properly in Salesforce Picklist two doesn’t show up properly in Zapier, can’t select correct options and shows up as all. example of pre-filled selected fields in Zap, can only populate apparel as a custom optiononly custom option that shows up is apparel :( not the other categories. Please help me understand what I am missing <3 Olivia

Mitchell ZezimaBeginner

asked in Code & Webhooks

Zap is running twice (Duplicate trigger)

Hello, I am trying to follow this article: I am trying to get this to work by following the code step described in the above post, I feel like I have it set up correctly but its still triggering twice. Heres some screenshots of how I have the Zap set up and the Zap runs history. Have I done something wrong? Regards

asked in How Do I

How can I update a Google Sheet with a CSV from a Microsoft Outlook email?

How could i take a CSV in an outlook email and have it update a google sheet?

andreajordanNew

asked in How Do I

How do I trigger Zapier Zap only when the value falls below zero in Google Sheets?

Hi I managed to create a Zap that create a draft email when rows are updated on a oogleSheet file. It works pretty fine. I wuld like to tune it a little bit.Actually I want the email to be created only when value of cell D2 falls below zero. In the google Sheet i put a formula that says … IF( D2 is greater than 0, False, “D2”) In this way zap doesen’t gets triggered at every change of data but if the value of D2 falls below 0 ZAP gerts triggered, but it happens also when D2 raise again from zero. (i.e friend top up their credit of a car we are using toghether)Can you suggest a way so that zap is triggered only when value falls below zero?I cannot think of anything.Thanks

asked in How Do I

Creating Google Drive Folders from Form and Upload to new Folder

Hi I need some help creating a Zap for my client onboarding process. What I would like to do is the following:1. Trigger - Google Forms SubmissionCreate New folder based on this submission Upload files submitted in the original Google Form to the newly created folder any help on this would be great Thanks Dan

asked in Troubleshooting

Twitter error: Token request failed with code 401, response was "errors. code":32,"

Hello, it is no longer possible to link zapier to twitter? My zaps no longer work, yet I see among competitors that you can use Twitter with the developer section. thanks for your help Token request failed with code 401, response was '{"errors":[{"code":32,"message":"Could not authenticate you."}]}'. Nicolas

PzoneliverpoolNew

asked in Troubleshooting

Google Calendar entry from Zoho Books showing incorrect end date.

Hi. I have created a Google calendar entry from a Zoho books form I only want this as a one day, all day event so I use the event date from my form for both start date and end date in the Calendar action but for some reason it changes the end date to a day before the start dateI can't use formatter to fix this as I'm on a free account Thanks

asked in How Do I

How do I integrate the Street estate agent website with Zapier for personalized emails and WhatsApp texts?

Hi Guys, I’m an Estate agent in the Lincolnshire area and i am looking to uprgrade our system to allow us to send more persional emails from our system “Street”, which is a specialized estate agent website, using features that Zapier has like the Automated Whatsapp Texts and emails. Has anyone got any experience with street and zapier intergration

sun-arcBeginner

asked in Troubleshooting

Getting "invalid_request_error" when sending Dropbox file to OpenAI

Hi!I am trying to send an mp4 file from Dropbox to OpenAI for getting its transcription (this Zap -- https://zapier.com/apps/dropbox/integrations/dropbox/1252350/create-transcripts-of-audio-files-with-openais-whisper) and I get “Failed to create a transcription in OpenAI (GPT-3, DALL-E, Whisper) The app returned "invalid_request_error".” I’ve tried all possible options in Action -> File field, but it does not work. I also tried to use another file, or even Google drive instead of Dropbox the result is the same: "invalid_request_error". I attach the screenshots, hope it will help to detect the problem.

asked in How Do I

How do I integrate Darwinbox HRMS with SysAid?

How Do I integrate Darwin box, HRMS application with SysAid? Is there any case study available or anyone tried that?

1
...
355
356
357
358
359
360
361
...
1127

Page 358 / 1127

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