Skip to main content

Get Help

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

28195 Topics
T
thomjobNew
posted in How Do I
Gravity Forms to Google Sheets List Field

Is there a way for a new row to be created in Google Sheets when a user adds to new row to a list field in Gravity Forms? 

1
robschmidt
1 year ago
T
techegNew
asked in Troubleshooting
Subscribing Failed

Does anyone know if the issue with Yoast SEO to Discord has been resolved, had this issue since October and heard nothing back and still have the same issue. The error message I get is; The app returned "Subscribing failed. A subscription already exists.".

1
Liz_Roberts
1 year ago
C
chrisgscottNew
asked in How Do I
Pull weekly conversion data from Drip into Google Sheets

I want to automate the process of tracking conversions week-to-week using Zapier, but I’m not really sure how to pull it off. I really just want to be able to see the running trends of how many new free trials our saas app gets on a weekly basis, without having to bug my dev team to build it out for me.The end result I’m looking for is the number of new free trials that start each week gets stored in a column in Google Sheets. I’d like to base this off of a custom event that is fired in Drip.So I think the general idea is that every time the “New Free Trial Signup” event occurs in drip, I need to increment the number of free trials started in Google Sheets, but I also need to be able to tell Google Sheets when to create a new column at the end of the week and to start over from 0.Or I suppose I could use Schedule by Zapier to just pull all of the conversion data from Drip once a week and cram it into a Google Sheets cell. But how do I get it to only count the number of times that event

1
robschmidt
1 year ago
C
chrisgscottNew
asked in How Do I
Pull weekly conversion data from Drip into Google Sheets

I want to automate the process of tracking conversions week-to-week using Zapier, but I’m not really sure how to pull it off. I really just want to be able to see the running trends of how many new free trials our saas app gets on a weekly basis, without having to bug my dev team to build it out for me.The end result I’m looking for is the number of new free trials that start each week gets stored in a column in Google Sheets. I’d like to base this off of a custom event that is fired in Drip.So I think the general idea is that every time the “New Free Trial Signup” event occurs in drip, I need to increment the number of free trials started in Google Sheets, but I also need to be able to tell Google Sheets when to create a new column at the end of the week and to start over from 0.Or I suppose I could use Schedule by Zapier to just pull all of the conversion data from Drip once a week and cram it into a Google Sheets cell. But how do I get it to only count the number of times that event

1
Liz_Roberts
1 year ago
T
The Chronic CC
asked in Troubleshooting
Filter out every n-th item from a lineitem or Printful order shipped

How would I separaste the 1,3,5,7,etc links passed from a printful order shipped trigger. The items ordered pass two links into “Items Thumbnail URL” where the 2nd URL is the desirable URL to keep out of the two for any item ordered.  I have 6 URLS and want every other URL from the item I cant seem to separate or truncate the right way, I want it to be dynamic to accommodate orders of different sizes

1
Troy Tessalone
1 year ago
C
ComputaTimNew
asked in How Do I
filter out everyother line item

I am setting up emails based off printful trigger for shipping confirmation- the trigger sends in 6 URLS that are all headed under “Items Thunbnails” tag, however every 1,3,5,etc is an image of the logo not the item, which is the 2,4,6,etc image url.  how would I filter out the logo URL’s to display only the 2,4,6 or even/odd number line item entities in the example above with 6 URLS, it’s 2 URLS for each item, and 3 items. The first link in each pair is the logo, second is the item

2
jesse
1 year ago
L
LMDocNew
asked in How Do I
Connecting a specific booking page in OnceHub

Is it possible to connect a specific booking page from OnceHub to Active Campaign. The current Zap between the two programs is pulling “all” bookings. Thank you!

2
christina.d
1 year ago
S
SamudraSEONew
asked in How Do I
How do I fill in the "Create Activity in Pipedrive" action?

HelloPlease help me solve the following Zapier to Pipedrive automation issues1. Why are the fields in Zapier and in Pipedrive different?2. In the "Create Activity in Pipedrive" action. There is no "Contact person" field, whereas in Pipedrive there is a "Contact person" field, how do I fill in this field?For more details, you can see the picture in the link that I attached Best regards

3
chanelle
1 year ago
J
JLOBeginner
asked in How Do I
Automatically forward to Clio Matter

I’m hoping to follow up on my question in this post:I think the solution Danvers suggested will work. I just don’t have the knowledge to execute it. What I need is a way to extract an email address from the text of an email. Thank you in advance for any assitance.  This is my original question: “Has anyone come up with a way to automatically forward email replies to Clio matters? Clio provides maildrop addresses for each matter that allow the user to send or forward emails directly to the matter. When I send an email regarding a case I CC the maildrop address so that the matter receives a copy. I'd like to set up a zap so that the response is also automatically sent to the matter. I could also include the maildrop address within the body of the email.”  This is Danvers reponse:  “Hi @JLO!Formatter by Zapier is a really handy tool for pulling out pieces of text from a field. The most efficient way to do it is by using the Extract Pattern function, which is under the Text events. Extract

7
Danvers
1 year ago
S
SKHCNew
asked in How Do I
How to Replay filtered Task

Hi guys,Any possible way to replay the task have been filter by zapier? Because I know it only can replay failed task but the Task have some minor Text error due to updated from payment provider side causing 3 month invoice never link from Shopify to Xero.I have just manually updated the Filter Text section but I'm not able to run past history of 299 invoice from shopify to Xero.Is there any possible way to replay it?Thanks– Kenneth Tan

2
christina.d
1 year ago
A
alon123New
asked in Code & Webhooks
Google sheet date field turns to random numbers

I created a webhook from my element or form to a google sheet.for some reason the date and time field I defined shows random numbers, what seem to be the reason and how do I fix this?* ill mention that the test from Zapier send those properly and the random numbers appear only when I send the form manually

1
Danvers
1 year ago
V
VINDBeginner
asked in Troubleshooting
Add OR update row in Google sheets troubleshoot

Hi, I need some help with the Add OR update row in google sheets. Couldn't answer on the excisting topic. Somehow I can't get it managed to work. Gravity Forms - Form Submission Lookup Spreadsheet Row in Google Sheets Lookup Column: E-mail (COL$F) Lookup Value: Gravity Forms E-mail No supporting lookup column Bottum-up: no value Create Google Sheets Spreadsheet Rof if it doesn't exist yet = YES (tag placed) Update spreadsheet Row in Google Sheets Event: Update Spreadsheet Row Row - Custom - ID Selected all the columns which should be updated with the right gravity forms data What am I doing wrong?  

4
rachael.silvano
1 year ago
H
hkalebjianNew
asked in How Do I
How can you get an example url from the Shopify API?

This question was originally posted on the aritcle:  HI there. I’m following your steps but the Shopify API doesn’t display a url example anymore. Any idea on how to get it?

1
Troy Tessalone
1 year ago
B
bz181d
asked in How Do I
How to sync Monday.com to Google Sheets and then keep them in sync

I have a CRM board in Monday.com which has contact details for my suppliers. I would like to create a Zapp that pushes the data of this CRM to a Google Sheets file. After the initial push, I want it to always be in sync so if any new items are created in the CRM or existing ones updated, Google Sheets updates to reflect this.How can I do this? I saw the options below but not sure which accomplishes first A) the initial push of all the data (given that the Google Sheet is empty now) and then B) the continual update + sync.  

4
christina.d
1 year ago
B
bawaNew
asked in Troubleshooting
The app returned "'500' is not of type 'integer' - 'key'".

I’m getting this error when I pass the int value to the `key`

1
Danvers
1 year ago
J
jsharprippleBeginner
asked in How Do I
Zoho - Zap to Google Calendar - delete an entry when deleted in Zoho

I use Zoho for my CRM and add events in Zoho as a Deals module.I have successfully created the zap that finds, creates or updated the record in my apple calendar (via a google calendar).However, if I delete an event in Zoho, I want it to delete from the calendar too.  Zoho has no option for delete in Zapier.How do I achieve this?

4
J
1 year ago
J
jparnellBeginner
asked in Code & Webhooks
Webhook to excel save question

Webhook is providing data to an excel spredsheet throughout the day and after a certain time (ex. 1:00PM) we want the zap to do a save as and place into a folder in onedrive business.  Does anyone know if this can be done?

4
Troy Tessalone
1 year ago
D
dunkstewartNew
posted in Code & Webhooks
Sending selected text to Zapier via a chrome extension

I created a simple chrome extension that sends the currently selected text to Zapier via a web hook. It solves the problem asked in this question - Select Browser/Website Text, Right Click, Send To Zapier - Searched all day for the answer, can someone help?I built it to streamline my own product research with Dovetail.It’s called Post Selected, hope others find it useful :) Duncan

0
D
1 year ago
J
jrolfeNew
asked in Code & Webhooks
Is there a simple way to validate json?

I have a number of zaps that receive data via a webhook.  I then need to build a different json string using SOME of those fields, some other custom data, etc. to post to a different api using a separate webhook action.  It’s pretty simple, and all works well until some of my fields have invalid characters in them - like quotes or a backslash.  These end up invalidating the json because they are interpreted as string termination or an escape character by the system receiving the json.  In my case, it’s Splunk sending data to a listening Zapier webhook, which I then manipulate and send to a Cisco WebEx space using a custom webhook action.I can fix this by adding a “formatter” action and doing a string replace on any given field for any given character, but when I’m building a json string of say 15 different fields from my initial input, all of which “might” have a “ or a \, then that’s a very inefficient way to format.  What would be ideal if there was a simple “validate json” action, o

1
Troy Tessalone
1 year ago
R
Rlaurence83Beginner
asked in Troubleshooting
Frame.io New Video Added Not updating to correct field Airtable

Not sure if this is a air-table or zaiper question hopefully someone can explain to me. This is what im trying to do:Uploaded video To frame.io where the name of the video is the same as a Unique ID in airtable ( called Asset ID ) in Airtable  search for a field ( Video Edit )  Input text or link  to inform that video has been uploaded I have tried to find the record using a search function and my zap looks ok but when i run it it does not update to the correct field. when i test the last part of my zap ( input text ) it will only place it in the first record and not the one attaching the unique ID  i have tried the following SEARCH functions also FIND SEARCH(({Asset ID}))!={Edit}SEARCH(({Asset ID})) = {Edit} not sure if it is that or when i go to set up my action in the RECORD section i am picking the wrong dropdown. i thought it may be “custom” “zap search was found” but didnt work , and i have also tried multiple other options  any input would be great :)  Happy Holidays    

5
R
1 year ago
M
Mark WinNew
asked in How Do I
Go High Level appointment from one subaccount to another

Hello Zapier Community!I am relatively new to using API and Webhooks and I am not sure how to format raw JSON data in order to get a successful response.I am building a zap that triggers off of someone scheduling an appointment on High Level and the zap should send the info of that appointment and schedule an appointment in a different subaccount.High Level API: https://public-api.gohighlevel.com/I am currently using this JSON data with all of the fields filled in from the previous step:curl --location --request POST 'https://rest.gohighlevel.com/v1/appointments/' \--header 'Authorization: Bearer <token>' \--data-raw '{ "calendarId": "CVokAlI8fgw4WYWoCtQz", "selectedTimezone": "Asia/Calcutta", "selectedSlot": "2021-06-23T03:30:00+05:30", "email": "john@deo.com", "phone": "+18887324197"}'I’m getting the response “Unauthorized” not exactly sure what to do, can you help?

0
M
1 year ago
G
GlobalSoulBeginner
asked in How Do I
Pulling in Big Cartel Product Info Through Zap

Hi!  I am using Zapier to integrate Big Cartel with Keap. I want to be able to tag new sales in Big Cartel in Keap with my product tags. I don’t see a way to pull through the product information so that it will assign the correct product purchased tag on each “NEW ORDER” zap. It just adds a new contact or updates an existing one….but if I add a tag to the zap it adds that one tag to every contact added or updated by the zap. Is there a way to customize the zap to read the product line and match the tag? Even if I have to create a table of matching products to tags. 

3
G
1 year ago
N
Naveen_rk22Beginner
asked in Code & Webhooks
Does Zapier provides Updating Freshdesk fields?

I’m trying to create a flow between ClickUp and Freshdesk. Whenever the status is changed in ClickUp, I want the status in Freshdesk to be updated. So, I tried searching for an action for the above scenario but unfortunately, I don’t see any event for updates (it shows only Create and Search events). Please let me know if Zapier has the status update functionality or not for Freshdesk. Thanks in advance.

4
N
1 year ago
R
rokinisgritinisBeginner
asked in How Do I
How to send email when Stripe subscription is canceled?

Hi,How do I automatically send an email to a customer via Sendfox when he cancels his subscription? There is integration with Sendfox but I fail to see a “send email” command. Are there any workarounds?Thank you. 

3
R
1 year ago
R
rokinisgritinisBeginner
asked in How Do I
Stripe trigger when the subscription period is coming to an end.

Hey guys, I want to set up a trigger when the current membership period is coming to an end - i. e. 3 days left until recurring payment happening.I want to email the customer and suggest him to switch to a longer period plan to save money.Is there any way to do that?

1
rachael.silvano
1 year ago
Terms & Conditions