Skip to main content

Get Help

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

28156 Topics
H
hbwebBeginner
asked in How Do I
Woocommerce Google sheets

Whenever I get a new order I would like to take line items from those orders and put them into certain cells on my Google spreadsheet.    For example, if Customer A orders 1 meatball dish and 2 apple crisps, the spreadsheet row would update with their name and a quantity of 1 in the meatball column and a 2 in the apple crisp column.   If Customer B orders 3 pasta dish and 1 meatball dish, the spreadsheet would show 3 under pasta and 1 under meatball.   I’ve tried to use line items as output, but depending on the order line item 1 could be a meatball dish, an apple crisp, or a pasta dish.    Is there a way to look at the order see that a line item contains a certain product and put that products quantity until the correct cell? Thanks!

5
AndrewJDavison_Luhhu
4 years ago
J
johnrhopkinsBeginner
asked in How Do I
Adding a checkbox to a google sheet?

I have a zap that adds a new row to a google sheet with each new lead we get. How can I have one of the cells be a checkbox? I can add the true/false checkbox in the sheet manually but cannot find any documentation on adding it via Zapier.

5
Liz_Roberts
4 years ago
W
williamchBeginner
asked in How Do I
How to import XLSX to Google Sheets

Hi There,   I’m hoping to solve a very similar issue to this post, but with xlsx files instead of csv’s.    Essentially, I get regular emails with xlsx attachments that I would like to take and put the entire contents of the xlsx file into a google sheet, overwriting the sheet whenever there is a new email with this attachment.    My first step: I have the trigger as Gmail receiving a new email matching a certain rule that I’ve created, and the event as finding the data in the all_attachments.  I’m trying to work with the Formatter from there, but I am not getting anywhere.   Any help is appreciated!   William 

5
nicksimard
4 years ago
X
xenoBeginner
asked in How Do I
Create custom object line item records in Salesforce

I wish to create a a custom record and child line item records in  salesforce when a new Bill is created in Xero. I need advice on how to create a record and related line items if the Action does not support line items. (The trigger does support line items.) I believe I need to convert each of the Xero Bill line items to a delimited text string? Then when creating the parent record in salesforce, the line item text string should be mapped to a Text field and then use Salesforce workflow to create the line item records from this text string? If this is correct I cannot figure out how to use formatter to create a single text string for all the line items. Any help or other solutions would be much appreciated: 

5
nicksimard
3 years ago
Let's Dive Brazil
Let's Dive BrazilBeginner
asked in How Do I
Create deal activity in the Pipedrive

Hi guys! I need help with a zap on pipedrive! I created a zap where when a customer fills out a Google form, he sends it updates all the data with the person's profile on pipedrive. So far without a problem! But I also need that when that happens create 2 activities in this person's deal. The problem is that I can't find the related deal. I filmed the screen to make it clearer:  https://www.loom.com/share/4cf890b965dc4b35876462d2e747ee3f Can someone help me, please? Thank you!

5
steph.n
4 years ago
P
PhilippeBeginner
asked in How Do I
Issue between Zapier and Ninja

Hi, I need to create client and invoice on Ninja, I use Zapier I can create a client but when i want to create an invoice, the client is not found Any help?   Thanks Philippe

5
Danvers
4 years ago
Bananero
BananeroNew
asked in How Do I
Adding GotoWebinar Registrants through Google Sheets for a paid Webinar

I’m having an issue adding registrants to a paid GotoWebinar through Google Sheets. If the GotoWebinar is free the registrant is added without issue, but not when it’s a paid Webinar. I am receiving: 400 Error: Payment info not available for paid webinar I am unable to see any fields that require payment info, but maybe i’m missing something?….  Please Help! Best Regards

5
steph.n
3 years ago
M
MichelleWilliamsNew
asked in How Do I
Zoho Books - create invoice with multiple line items

I can create an invoice in Zoho Books with a single line item but I can’t see a way to create multiple line items. Has anyone come across this issue?  

5
S
2 years ago
R
RussellFBeginner
asked in How Do I
How do I update a customer object in Salesforce when a bill payment is made in QuickBooks Online?

I don’t see that there is a way of having bill payment as a trigger in QBO. I want to be able to update a customer object in SalesForce (and potentially other transactions) when my finance team make a bill payment in QBO. Is this possible? - maybe it is my undertanding Is this planned? Can anyone help me make this as a custom zap? Thanks Russell

5
O
6 months ago
L
LaurentBeginner
asked in How Do I
Facebook "New Event" trigger

Hi guys,    In this page https://zapier.com/apps/facebook-pages/integrations/google-calendar, there is mention of the “New Event” trigger and a lot of other ones. How can I use it, access it ? When I create a new zap I only get 3 Facebook PAge Triggers : New Post to Your Timeline, New Recommendation, New post by you.   Thanks for your support, Laurent.

5
S
4 years ago
C
crovinelliBeginner
asked in How Do I
How to set a fallback for an Airtable lookup

Hi there -  I setup a Lookup table in Airtable that I use to map a “city” value that I receive from Clearbit to a  “region” value that we use internally.   It works great - unless - the city isn’t in my Airtable. The Zap stops and I am sad. Ideally, the Zap would just continue… it’s ok if the field doesn’t resolve to anything, I’m ok with it being blank.    Is there a way to set a ‘fallback’ so if it can’t find a record, the Zap just proceeds?   Thanks!

5
C
4 years ago
N
njinsuranceguyBeginner
asked in How Do I
Constant Contact Zap - Will it update with every campaign I create?

I set up constant contact to put a note on my crm when someone opens an email and it’s working fine but zapier made me pick the campaign I was doing the zap for. My question is, will zapier add these notes for EVERY campaign I send or will I have to adjust the zap everytime I create a new campaign?

5
AndrewJDavison_Luhhu
4 years ago
A
AlexPeralta2020Beginner
asked in How Do I
Change status from False to True

Hi there,   I’m currently on a company plan but posting from my personal account which also has a similar Zap in place.    The purpose of my zap is to detect when someone replies back to me from LinkedIn and I’d want to see the status in my Google Spreadsheet be switched from FALSE to TRUE. However, I don’t see an option to change it from FALSE to TRUE or does it automatically switch.    In the screenshots below, “choose action event” is set to “lookup spreadsheet row” and shows an option of bottom up value. However, under my company account  the “choose action event” is create spreadsheet row and I no longer see an option to select true or False.    Please help. Happy to do a video on this too   I’ve included some screenshots detailing this.   

5
Danvers
4 years ago
M
MatthewzapBeginner
asked in How Do I
Split text on line items

Hi @Danvers  I’m trying to do something similar. Zapier clearly has split the text into a list of some sort with an index. But on the following step they come in as 1 field. How do I extract say index 2 from that?  

5
A
4 years ago
I
izmad84New
asked in How Do I
YouCanBookMe to Zoho CRM error

I’ve created a Zap between YouCanBookMe and Zoho CRM. I’m trying to map a custom input to the ‘Lead Owner” field because the owner isn’t always the same. The error I get is  Unable to create entry in module: Leads. Error : Invalid data for the field Owner   The lead owner dropdown shows a Name/Owner ID number, Ex.John Smith/4212086000000237011. My custom input maps the Owner ID number, 4212086000000237011, but I get the error.

5
nicksimard
4 years ago
C
casedog3000Beginner
asked in How Do I
Extraction from "Get Many Spreadsheet Rows (Advanced, With Line Item Support) in Google Sheets"

Hey all, thanks in advance for any insight into figuring this one out. I’m using the “Get Many Spreadsheet Rows (Advanced, With Line Item Support) in Google Sheets” Zap and the output I get is either “Rows” or “RAW Rows.” Then I’m using the Zapier format Text Zap to remove all of the “$” from the output. Then ultimately I’d like to create new spreadsheet rows in an existing Sheets doc using this data but I’m having some trouble with how to work with the output I’m given. I’d like to take the data and have it show up in the proper columns in the new rows. I’ve tried using the Post Webhook to format as a list, but I’m not sure how to separate the comma’d array into what would show as separate fields that I cal work with and insert into my Sheets Doc. I’m not a total noob so I should be able to interpret what you guys throw at me, but some assistance would be appreciated.   BONUS QUESTION: If my spreadsheet with line items happens to be more than 20 rows (max allowed in this zap), can I s

5
Danvers
4 years ago
B
BruceBeginner
asked in How Do I
Zap creation

I want to connect unbounce to an App/Company that is not on the list. Can i do that and if so what information do i need and what are the steps to accomplish it please? Specifically I want to connect an unbounce form to a sms company where the leads from the form will go. They have an API key and a document with info that i don’t understand. Thank you. I tried to upload doc in pdf and it won’t accept it here.

5
AndrewJDavison_Luhhu
4 years ago
M
mickwarBeginner
asked in How Do I
Line Item Task Usage

I’m trying to understand how Zapier calculates the number of tasks when using Line Items midway through the zap. I have a zap which runs 3 tasks. After the third task, 4 line items are processed in the final 2 tasks. In the task history, there will be 4 instances of the zap showing, each with 3 + 2 = 5 tasks used. If I’m understanding correctly, this would be 5*4 = 20 tasks used. But the first three tasks were only executed once, so I would think that the total number of tasks would be 3 + 2*4 = 11. It seems like I would be charged for these phantom tasks which aren't being executed. To take this to the extreme, suppose I have a zap with 100 tasks and then at the end of that zap I have 1 task using Line Item support for 10 items. Am I getting charged for 100 + 1*10 = 110 tasks or am I getting charged for 101*10 = 1010 tasks? A thousand tasks weren’t run, but that’s how it would look when viewing the task history.   Is there something I’m misunderstanding about how the number of tasks i

5
Liz_Roberts
4 years ago
J
jcgBeginner
asked in How Do I
Copying and pasting a folder in OneDrive

When I create a new project in Asana, I would like to copy and paste an existing folder in a OneDrive subfolder to a different subfolder. How do I accomplish this? I can find the existing folder I want to copy and paste, but cannot figure out how to copy and paste it in the new location. Thank you in advance. 

5
nicksimard
4 years ago
D
developer2389Beginner
asked in How Do I
New user WordPress to teachable

I want to add new user crated on wordpress to teachable account.  I guess user should added to teachable automatically but its not happening. When First time I triggerd action only then one user added to teachable but after that when I added new user to WordPress it’s not created in teachable account.       

5
AndrewJDavison_Luhhu
4 years ago
H
HumbertoBeginner
asked in How Do I
WooCommerce Zapier

Hello, Anyone knows why I keep getting this message “We couldn’t find a customer” when I tried to create a Woocommerce Zap. It works when I create an Order but not when I tried to create a costumer. Thank you.  HH    

5
AndrewJDavison_Luhhu
4 years ago
M
MichaelKellyNew
asked in How Do I
Salesforce SOQL multiple rows

Hello,   I am looking for a way to get a collection of related records in in Salesforce via SOQL query When an Opportunity’s StageName changes to ‘Closed Won’, I want to find all related Opportunity Products. The SOQL that I have written is correct, but I am encountering an issue; It seems as though I can only ever fetch the most recently created Opportunity Product. The end goal is to create a customer and a sale within Quickbooks Online, but if I can’t work with multiple Salesforce records within one transaction, then I will have to look for another technical solution.

5
Danvers
4 years ago
H
HammetBeginner
asked in How Do I
Looking for alternative to Zoom - zap event after the meeting

Hi I want to do some actions just after someone participates on an event on Zoom.  If it is not possible, do you know any alternative app to Zoom to do that?  Best  

5
steph.n
4 years ago
W
wangxiaokeNew
asked in How Do I
Can WordPress use the new post event of the specified category? Not all new posts

Can WordPress use the new post event of the specified category? Not all new posts

5
Danvers
4 years ago
D
DarkBeginner
asked in How Do I
Facebook Page doesnt show link properly

Hello everyone. I’m having a problem with the Facebook Page. I have connected it to my facebook acc and confirmed all the permissons. However when i try to text in Message Text, it always show “Link: zapier.com” it supposed to be link of my facebook post?  This happens when i try to connect my facebook page to discord. I used Facebook Group connect to Discord it works perfectly but i dont know why Page to discord it becomes like this. Can someone help me how to fix this? Thanks and sorry for my bad English  

5
Danvers
4 years ago
Terms & Conditions