Skip to main content

Get Help

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

28203 Topics
N
nathanbrownfaxNew
asked in How Do I
Car pooling via SMS

Hi allI’m not technically the most able, looking for advice.I’m starting a carpool system, and in the past we’ve used a google form. I’m wondering if it would be possible to set up a template/system whereby you would send a message, either by SMS or whatsapp or email, and the data you send would generate a google excel sheet. For instance I text “Nathan, to the city 10am, home again 4pm” to a certain number on whatsapp, or SMS, and my number and the content of my message appears in a live spreadsheet.Thoughts?

3
Danvers
2 years ago
W
wmflan650New
asked in How Do I
No options available when providing ID for the lead in MS Dynamics.

Writing a Zap to fire when HubSpot Contact is updated to update Lead in Microsoft Dynamics. All goes well for the test until I provide id for Lead: ‘no options available’. I have no idea how to proceed. Suggestions?

4
W
2 years ago
Z
ZapiaskNew
asked in How Do I
How to split leads from Facebook Forms into 2 paths?

Hi.. May I know if there’s a way to split leads from Facebook form into 2 different paths by rotation.exfirst lead to A path2nd lead to B path3rd lead to A path and so on…Thank you in advance..

1
Danvers
2 years ago
newmag
newmagNew
asked in Code & Webhooks
How to get the JSON response from a URL?

I have this URL https://newmag.com.br/wp-json/wp/v2/media/6358which returns  from that response I need to parse it and get figure URL in the fieldmedia details: full: source_url:https://newmag.com.br/wp-content/uploads/2022/06/Winona-Ryder.pngto feed into the next action and post it to Instagram.  

3
M
2 years ago
S
stylebaseBeginner
asked in Code & Webhooks
Importing a large list onto a Python code

  Hi Zapier Community I am running a Python code on Zapier and know that I cannot use libraries beyond the native ones.I am trying to import a list of strings that I use on the Python code as ONE huge string, which is a concatenate of all rows in a mySQL database. This long string doesn’t need to be regenerated every time, it will not change.  To generate this list on mySQL workbench I use the code SET @@group_concat_max_len = 3000000;SELECT group_concat(reference_field SEPARATOR ',')FROM Items; Which doesn’t work on Zapier, I’m guessing it’s SET function that Zapier is not liking because without i, the concat field works fine. But since the total length of the list of strings is ~3M characters, I need this SET function. I was also exploring storing the list of string values (or huge string value) in another file and using it in my Python code. But I can’t figure out what’s the best way to store a list of value (HTML, JSON,??) and how to import that onto Zapier so that it doesn’t look

0
S
2 years ago
H
Harry ZBeginner
asked in How Do I
One line of data in WPForms to two rows in google sheets

Aloha. I asked this question a couple of months ago and unfortunately had to step away from my project before resolving the issue. The previous question is closed, so I cannot revive it.  Apologies for the duplicationHere’s my issue: How do I take one “entry” from WPForms (i.e.: one line of data) and create two rows in my google sheet? I’m using WPForms to capture member registration information for a club. Most of the club consists of couples (e.g.: husband and wife), so I’ve created the registration form to gather information on both of them at one time.  So far, so good.The next step is to get the information out of WPForms, and into google sheets so that I can actually use the data. I’ve set up a Zap with the trigger to be a new WPForms entry. And I’m looking at the “Create Spreadsheet Row(s) in Google Sheets” action to hopefully add two rows (one for the husband, one for the wife). But I have NO clue how to do this.Here’s a link to a gsheet where you can see the ‘before’ and ‘afte

4
H
2 years ago
L
lifeisgoodBeginner
asked in Code & Webhooks
zap is not receiving notifications.

 I'm using Google spreadsheet and messenger app in conjunction. using zapier through web hook. today, The corresponding "zap" does not receive and receive notifications. check history, The notification has been stopped since the 27th.(yesterday) I entered new data in real time, but there is no response. The spreadsheet is being input normally. Others work normally.

3
christina.d
2 years ago
S
SeldomSceneNew
asked in How Do I
Create FluentCRM contact from newly created Oncehub booking

Hello,Looking to create a contact in FluentCRM after a OnceHub booking. OR suggestions for better solution than OnceHub. Thank you in advance

2
christina.d
2 years ago
I
IAOSNew
asked in Troubleshooting
My "dateTime pretty" field adds an hour to the event time, but the "dateTime" field shows the correct time.

I have a trigger setup that looks for a new event start in Google Calendar then sends out notifications before A meeting. The problem is the “dateTime_pretty” field is adding an hour to the event time, but the “dateTime” field is showing the proper time.   

1
christina.d
2 years ago
J
JustinBeginner
asked in How Do I
Outlook: Change which email address an email is sent from

Hi, I have managed to connect Outlook to Airtable with Zapier so that I can send emails directly from Airtable. But these emails are getting sent from my Gmail address (which I used to register for Outlook).  Can I change the email address that these emails are sent from? There are multiple email addresses linked to my Outlook account that is registered to my Gmail.

7
christina.d
2 years ago
C
ClearSBeginner
asked in Troubleshooting
iAuditor "Inspection Completed" trigger not activating when a new report has been completed.

The aim of my zap is to send a PDF, an editable link & a view only link of completed reports from iAuditor to a specific record on Airtable. The Zap worked for the test template in edit mode however once the zap was published it has not been triggered despite submitting new data (inspection completed button on iAuditor). Any help or suggestions would be greatly appreciated.

1
christina.d
2 years ago
V
ValiantBeginner
asked in How Do I
How do I update a WordPress post to add information to the bottom/top of the article instead of replacing it?

Hello,I’ve set up an automation to update an existing wordpress post with certain information I have from google sheets.Let’s say that first section of the post is one google sheet row worth of information.The issue is that when there’s a new row added, instead of adding the information BELOW the first section, it just replaces/edits the section that’s already there.Is there any way to fix this? So that when I trigger update post in wordpress option, it will actually start adding the information at the bottom (or top) of the article, instead of replacing already excisting text?Thank you

1
christina.d
2 years ago
B
BFTNew
asked in Code & Webhooks
Adding +1 to a cell.

I’m looking to have my webhook add +1 to the number already in a cell. I’ve tried =(c8)+1 but getting a #REF error. Any ideas how I can take the number already there and add 1 to it? 

2
GetUWired
2 years ago
A
AgriZapBeginner
asked in Code & Webhooks
Pick off a Child Key Syntax

I an trying to use Pick off a Child Key but when I use the syntax as below it doesn’t work:This is a subset of the payloaddata[contact]{:id=>"61d8326f88d0cd60e710e5e7", :first_name=>"TEST FIRST NAME AAABB", :last_name=>"TEST LAST NAME", and I an adding “contact” as the key

8
jesse
2 years ago
C
CtrlAltDeliriousNew
asked in How Do I
How can I send Discord messages to a Google Sheet based on the user that sent it?

Don’t know if its possible but what I am trying to do is make a chain that will see when a new discord message is sent in a channel with specific text then send the User who sent it and the date it was sent into a google doc then  populate that date into a specified cell in a roster document based on the User name and only update that persons last time they sent a message.Example: A Discord Message:Dave: Hifirst google docUsername      Date Message SentDave                   6/29/2022   <-------------------------                                                                              |    Move this date to second google docSecond Google Doc                                              |    based on the user name.Username     Blah Blah     Date                            |Dave                                 6/29/2022  <--------------Sally                                   6/14/2022

3
jesse
2 years ago
O
Optics TradeBeginner
asked in Troubleshooting
Trouble with Magento 1 and Google Sheets

Hey guys,I am trying to automatically transfer a few pieces of information from a new Magento order to a google spreadsheet. But when I want to select "payment information" (example: moneytransfer, paypal, credit card...), which is shown in Magento orders, but I can't find it as an option in Zapier when selecting which fields/elements I want to transfer to a new spreadsheet row.I hope someone can help me. Thanks, to anyone who will take the time to help me.

4
jesse
2 years ago
J
JoseDojindoNew
asked in How Do I
How do I copy all the information from the Shopify order to create a new invoice within QuickBooks Online?

Hello everyone,  We have had issues with other apps regarding the name/number given to invoices created using shopify→ QuickBooks applications. Is it possible to automate the following upon fulfillment of a shopify order? Create a new invoice within QuickBooks (this is an important first step, because we want the invoice # to be the next in the existing sequence) Copy the rest of the information from the Shopify order (including data from custom fields/metafields) And finally, would this be possible with a single multi-step Zap? I am not familiar with the Zapier system, and hopefully this is possible without requiring a large number of Zaps per order. Thank you!

5
jesse
2 years ago
R
RelliottBeginner
asked in Troubleshooting
Re-playing Zap runs through edited Zaps

Hi, I have several zap runs that have been filtered due to an error in the filter. I have edited the zap to be correct. I would like to now re-run the filtered zaps through the same (updated) zap run. Is this possible?

2
jesse
2 years ago
D
dpzapperNew
asked in How Do I
Why are jpg/png files converting to txt documents?

I upload a .jpg/.png image but I receive a .txt document instead and have no idea why/how the file conversion is happening.Please help!

2
jesse
2 years ago
H
heominNew
asked in How Do I
How to get Twitter image URL

I'd like to get the image URL of my new tweet.But I don't know what to do.Help me.

2
jesse
2 years ago
D
dianasyBeginner
asked in How Do I
Group emails notification to avoid sending multiple emails of the same topic.

Hello Community,         I have an existing Zap that looks like this: Zap IllustrationIn a scheduled basis, it sends an email to remind people (column email)  to fill up a column1 and column2 if they are blank. Pretty simple if you think about it. However, I would like to avoid sending duplicate email if the person responsible (email column) appear more than once in the row. In this example, I don’t want xyz to have 3 emails of the same topic. I just want to nudge the person to go in and fill those column up. How can I accomplish this?  In the similar case, I also have another zap that triggers when a new row is created, doing the same thing (Email the person) to fill the field. Same case, I don’t want zapier to send dup emails. Any help is appreciated.     

4
jesse
2 years ago
A
adamjubertNew
asked in How Do I
"Find Contact in HubSpot" partial match

PrefaceThis question was asked once before, with some helpful Zapier mods offering to submit a feature request. Unfortunately, the OP never responded, and it looks like this feature still doesn’t exist!BackgroundOur Sales team offered leads their “third month free” if they became a customer. After a lead is converted to customer, became_a_customer_date is filled in with a timestamp (ex. 2022-06-30T17:08:03-400). GoalIn plain EnglishEvery day, we want to find all customers in Hubspot who became a customer exactly 2 months ago and turn off their Stripe payment. (there would need to be a second Zap doing the opposite, i.e. find all customers who became a customer exactly 3 months ago and turn it back on, but I digress)In Zapier termsTrigger: Every Day Action: Formatter by Zapier: Action Event: Date/Time Transform: Add/Subtract Time Input (today’s date in timestamp form from Step 1, e.g. 2022-06-30) Expression -60 days Action: Hubspot: Action Event: Find Contact First search property

2
jesse
2 years ago
M
may2022Beginner
asked in How Do I
Department field in Quickbooks

Hi Anyone here know how to use department field in Zap, in Creating Quickbooks journal entry? We are monitoring properties in Quickbooks and I think this deprtment field is some what related in our Quickbooks set up. 

5
jesse
2 years ago
A
Anonymous
asked in How Do I
Zap action to retrieve data in sheets

Hi all. I have a zap where it insert the row to the sheets whenever there is form submission. However, I would like to create another zap to retrieve all the data of the row in the sheets.The trigger action is row inserted in sheets, then send email. But when I test trigger, it shows only the row and ID, no other data anymore. The reason for having two separate zap is because I have some columns in the sheets that set the value through the formula. Is there any suggestion or solution for this?

1
jesse
2 years ago
T
Two Wheel CompanyNew
asked in How Do I
How do I do a gross profit calculation from Pipedrive deals and product costs from within my Zap?

Hi there.We are currently using Pipedrive as our new CRM system, and have created a custom field called “gross profit” which should be a calculation of.Gross profit = Net profit - cost of products.When connecting pipedrive and Zapier i am able to retrieve the Deal Summary (total price) of a deal. And i am also able to retrieve the cost of the associated products. For example 1000,1000,5000,300Those values should be used for making a calculations:1000 + 1000 + 5000 + 300 = 7300. And after that i can make the Gross Profit calculation:Gross profit = Net profit (Summary / total price) - the calculation.But i am having trouble on how to take the numbers, and divide them and thereby making the calculations.Can someone help on this issue?

1
Danvers
2 years ago
Terms & Conditions