Skip to main content

Get Help

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

28633 Topics
J
JasperNNew
asked in How Do I
#REF Connect 2 Google Sheets with each other possible through Zapier

Hi, I have the following Zap User subscribes to email list Trigger: Copy Google Spreadsheet 1 Trigger: Copy Google Spreadsheet 2These Google Sheets are communicating with each other through =IMPORTRANGE, which is fine, but as soon as a copy is made, the files require to be given access again to communicate with eachother. Since we want this all to be automatic we are wondering if this above part is also possible with Zapier. Sheet 1 is the Sheet which is shared with the new email list subscriber.Sheet 2 is the “backend”. Here are all the secret formula’s, which help the user get to a certain answer on Sheet1 without revealing the formulas.

2
J
1 year ago
A
Anonymous
asked in How Do I
Confused about the Instagram to Youtube zap works

Confused about how the Instagram to Youtube integration works if anyone can enlighten me…Does the Instagram to Youtube Zap only publish VIDEO media? or does it post all posts and if so - how? Should “#shorts” be added? What do you use for the title?Sorry, very new obviously. I’ve used IFTTT so I’m somewhat familiar with this sort of triggering, but would rather ask before flooding my Youtube with strange content. Any help appreciated!

4
A
1 year ago
M
MarkSteppNew
asked in How Do I
Complete list of Zap actions

Hello All - Is there a way to get a complete list of ALL ACTIONS/SEARCHES for ALL ZAPS?   I’m trying to build an integration resource that gives a brief explanation of what Actions/Searches each Zap could perform given the correct input.  I know I can go to each ZAP individually and see the ACTIONS list but I’d like to see that ACTIONS list for ALL Available Zaps…   (Might be good to have the triggers too but I’m mainly interested in the ACTIONS and SEARCH)

1
Troy Tessalone
2 years ago
C
cnorris_10Beginner
asked in How Do I
How do I automatically email task details from Asana, using Outlook, once a task is completed?

Hello,  I am trying to create a Zap that will allow me to automatically send an email out (via Outlook) to a client that has a link in the body of the email. That link will be copied/pasted into a task comment or description and will be unique to that task each time. Basically, I’m trying to work around having to compose a new email every time we add this link within the task.  (note: we are a social media management agency and the link I’m sharing are upcoming post preview links) Thanks for any help or alternative suggestions you can provide! 

9
C
2 years ago
S
SkibonesNew
asked in How Do I
Client name missing from Harvest

For some reason zapier will not show the client name when writing a zap to create a new record in Airtable… it shows the client ID, but not the name… any ideas?

5
nicksimard
2 years ago
T
tesssmaniaNew
asked in How Do I
Ninja Forms > Check date > Send e-mail (ActiveCampaign or other)

Hi, When a ninja form coms in with a certain date, I want my availablity checked in Google Sheets or excell and if that date is true or false to send e-mail A of B with activecampaign depending on true or false. I have tried to set it up many times, but it never worked. Is there anybody who can help me of point me in the right direction? Is this possible at all? Regards,Tessa 

7
T
2 years ago
D
dl_adminBeginner
asked in Troubleshooting
Mailchimp Transactional error: Failed to fetch choices. Response payload size exceeded maximum allowed payload size

When using Mailchimp Transactional in a Transfer, the “select template” dropdown field does not get populated if there are more then +/- 60 templates available in Mailchimp Transactional / Mandrill.Zapier returns an error: “Failed to fetch choices. Please make sure all previous required fields have values. Error while invoking: Error during execution: Response payload size exceeded maximum allowed payload size (xxxx bytes).  

3
SamB
Community Manager
8 months ago
T
thartgrove86New
asked in How Do I
Create new Google (or Excel) Spreadsheet with only Select Filtered Rows

I’m looking to trigger creating a new Google Sheet, Excel Spreadsheet or PDF that takes only a select number of filtered row items from a current master Google Sheet. , I’m not picky on the service or app used if the integrations allow this to be done easier.i.e. My master sheet has a list of 50 items, 10 of those items have a “Job ID” of “105” and the other 40 have an ID of “107”. I want my Zapier trigger to pull the Job ID from another app, and gather the line items with that Job ID, and create a new sheet or PDF with only those rows (items).As far as I can tell, the advanced Google Sheet filter only does up to 20 items, which isn’t enough since some of my Job ID’s will have hundreds or thousands of items.Is it better to find a way to copy the entire sheet and delete all but the relevant rows, or create a new sheet and have it copy only the relevant rows? Is this process even possible with what Zapier can offer through any current integrations?Thank you for any suggestions.

1
robschmidt
2 years ago
L
LeeU-SalesforceBeginner
asked in How Do I
Parsing WooCommerce Email with Multiple Items

Using Parser by Zapier i am hoping to strip the items from a woocommerce order so that i can send those items to a row within excel. How/What is the best way to parce out the order items and have it so that they layout in a readable format?

5
L
2 years ago
Z
ZapMaguBeginner
asked in Code & Webhooks
Webhook Post sending data in wrong order

Hi guys.  When I do a webhook post, the data I enter needs to be sent in the order I enter it, however when I test the zap, it sends it in alphabetical order. Is there any reason why this is? I am sending data to do a s3 data upload.  Thanks  

10
Z
1 year ago
M
MWMNew
asked in How Do I
Zapier import from Stripe to Quickbooks adding VAT twice

We have an eCommerce website that is automated so when someone buys something they download it straight away. We want to make everything automated and have linked Stripe to the site and then used Zapier to link Stripe to Quickbooks to create a sales receipt and expense for the fee.  The only issue I am coming up with is that the prices on our site and the sales Stripe takes include VAT but I can not work out how to tell Zapier to tell Quickbooks that. So when a sales receipt is created in Quickbooks it is adding VAT again - therefore all the prices are wrong i.e. £12 sale (which includes VAT) but when sent to Quickbooks the sales receipt says £14.40 with £2.20 VAT so it has added it again. Any ideas who to move this across to include VAT so that is shows up correctly on the sales receipt as being £10 services + £2 VAT = £12 total sale?

2
christina.d
2 years ago
F
FrankPBeginner
asked in How Do I
Any Successful users of Adobe Photoshop Lightroom?

Attempting to use a BETA application in a Zap, Adobe Photoshop Lightroom. I’ve found very little documentation on it, the best yet is actually hosted by Adobe (https://helpx.adobe.com/creative-cloud/help/adobe-photoshop-lightroom-for-zapier.html) I’m attempting to get it work in any capacity and then will weave that into more complex zap but am struggling at the most simple zaps. I can get my trigger to work properly (new file in OneDrive) but Adobe requires the following fields which I am not sure of a value to enter: Input File Storage - Do I put the OneDrive file URL, file path, ID, File?Input File Location - Same as above, not sure what to use hereOutput File Location - Less concerned about this one but any guidance is appreciatedOutput File Storage - OneDrive File Path? Above are the basic fields, there’s also these ones below which are even more foreign to me:Presets File StoragePresets File Location  

1
christina.d
2 years ago
Z
Zapman123Beginner
asked in Troubleshooting
Zap between dropbox and woocommerce (listing gets created when image file uploaded) i'm stuck with how to have the dropbox image as listing image

I’ve been able to create a listing when i manually point the img url to an image located on a web server but i’m not sure how i could have the image i’ve uploaded into the folder as the listing image. 

9
Troy Tessalone
1 year ago
U
user23841New
asked in How Do I
Use Zap to Update Existing Event in Google Calendar (Google Forms)

I have a Zap set successfully to create a new event when someone submits a google form. All working fine.If someone edits their form response, I want to edit the calendar event to match.I assume the process is something like this: I have tried to edit the Forms (Responses) spreadsheet, but I can’t find the right row to use. I don’t seem to be able to add a Calendar ID.Any help appreciated!Thank you

1
U
2 years ago
G
gules_wineNew
asked in How Do I
Trello and Jira update cards

Hello guys, I wanted to ask, I easily set up the synchronization of adding new cards between Trello and Jira. But when I want to do an update synchronization, I am offered to link the necessary cards between the two systems. Cards are created all the time and there is no point in setting them up every time. Is this really how it's meant to be and is there no way to automate it?

3
Danvers
2 years ago
C
claudiamichelbachNew
asked in How Do I
Trigger: Move Jira ticket > Asana ticket movement

hi there,  I’m kind of referring to this question here:  but as far as I see this is still an ongoing topic. Nevertheless wanted to ask if someone has an idea how to realise the following scenario: What I already have automised is once a Jira ticket w/ certain specs is created, a Asana ticket is created as well (✅) What I now want is moving the Asana ticket to a different column once the Jira ticket was moved to a different column (e.g. from column “Backlog” to column “In Progress” → same should happen on Asana as well as board structure is identical)So what I’m searching for is:Jira trigger: Card movement Asana action: card movement Thanks for your help!

2
SamB
Community Manager
8 months ago
S
skybooktravelsNew
asked in How Do I
How can I stop my Zap from auto-generating new cases in Jira?

Integrated Wati with Jira using Zapier. But cases are being auto-generated. How to resolve it? 

2
jesse
2 years ago
A
Ash88New
asked in How Do I
Triaging Slack posts to derive insights within Airtable.

Hello All! I’m trying to get some help on a task that I believe Zapier can be helpful for.  I currently have a very busy Slack channel that everyone in the company uses to ask questions about my product. I'm trying to make sense of all the posts from the past and those that are coming in.  And by “make sense,” - I want to identify trends and potentially be able to provide better/more documentation for pain points or even use insights as an input for our roadmap. I know it's hard to triage automagically for unstructured data, but maybe if I come up with a few keywords, it would help triage better? My question: is there a way to be able to take all the contents of the slack channel and tag/triage posts towards understanding where the pain points are for our customers?I had an idea to connect Slack to Airtable, but outside of creating multiple “if “ + “contains” statements that look at keywords in a message, it seems like it's hard to scale - especially if I want to add new keywords. Also

3
christina.d
2 years ago
Y
YidiBeginner
asked in How Do I
How to extract details from an email

How can i get each field to go to the right column in the CRM.The email I get is in the following format:  Name: Elu*** Weis***Email: Eluzer***@gmail.comPhone: 34752*****Message:Amex cancelled ***** ***** ***** *** ****** ***

1
Troy Tessalone
2 years ago
A
Anonymous
asked in How Do I
Help with Google Cal Zap (email users with specific ResponseStatus)

Hi, i’m trying to create a zap for Google calendar that looks like this: Trigger: 1 day before event startsIf Atendee reponse status = needsAction or tentativeAction: email those attendees only (ignore the ones that have a “ declined “ or “ accepted “ status)Condition: Trigger only once I feel this being super easy, but the answer escapes me.Thank you for helping.

3
A
2 years ago
S
staxieBeginner
asked in How Do I
Is there a way to cross-reference data and let us know which contacts are on HubSpot but not on RnD?

Hi! I’m trying to build a zap between Scoro and Salesforce. Scoro is a project management tool for a specific team at my company and I’d like to set up an integration FROM Salesforce TO Scoro. So when an opportunity is closed won and matches specific criteria, the zap should create a New Quote in Scoro. We use Products in Salesforce that roll up to the total contract value. I can’t find the Products object in the drop down in the Actions section when creating the Zap. I think it’s likely due to the fact Products are a custom object created in SF. Anyway I can get around this and pull that data into Zapier? I’d like to pull the the Product Name, Quantity, and Unit Price to the corresponding fields in Scoro.  Thanks in advance!

5
jesse
2 years ago
N
noorayBeginner
asked in How Do I
I'm unable to access the name field from the Airtable trigger

 Hi, I am just automating one scenario in which i want to send interview invite on willo when I enters new record on airtable. But I need to send full name and email of candidate on willo from airtable base. PLease guide me in correct syntax to achive it. I am unable to see the fileds list of record in field section e.g. In Full name I am only getting record Id not a specific field name for this record. 

4
Danvers
2 years ago
H
hgruhnNew
asked in How Do I
How do I upload new google drive file to follow up boss contact? Or at least add the link to the file in the contacts note section?

I have a multi-step zap set up for a form submission from squarespace. It creates a new google doc with the users submissions and also creates a new contact in follow up boss. How would I add a step to add the link to the doc or upload the file itself to this contact in follow up boss?

6
christina.d
1 year ago
A
Andy ListerBeginner
asked in Troubleshooting
Can’t select Organization in Zoho Inventory - “trouble loading ‘Organization’ data” error

Hi folks,I’m trying to connect my Hubspot account to ZoHo Inventory to save time setting up accounts in both. Both accounts are Ok in terms of their log in details in Zapier  I can’t seem to find an acceptable option for this field, and there doesn’t seem to be anywhere in the programme that I can find out exactly what it wants me to put in there.  Please Help!

5
christina.d
2 years ago
J
juliacesanaNew
asked in How Do I
Dynamically update cancelled Calendly event in google sheets

Hey everyone,I created a Google Sheet to automate the process of sending gift cards to customers after they’ve conducted an interview. I currently have a zap running with Calendly and Google Sheets where it populates my sheet when an event is created. A gift card is sent to customers unless Column D has been marked as “cancelled.” Sometimes we deal with no-shows so I want to figure out how to create a zap that will automatically update Column D when we cancel an event. I’m a little lost on how to do this and would love any advice here!  

4
jesse
2 years ago
Terms & Conditions