Find answers to your questions. Ask the Community for help or hire someone to help you.
Repeating line item data in Shopify order export
I am sending data from Shopify orders to Google Sheets. I want it to contain all the line items of the products in the order, plus associated line item data. However, this leads to some order level data repeating. I would like to make it so that order level data only appears on the first row. It is currently like this And I would like it to end up looking like this; where anything not related to the specific line item is posted once
Send the same email every week in Systeme.io
Hello, I am using Systeme.io for collecting email adresses of my clients. I would like to send to some of them every wednesday the same email through systeme.io. I tried to use the trigger in Zapier to schedule every week an event (“Schedule by Zapier”), but the action following (register contacts to a campaign in systeme.io) cannot be done as the trigger does not contain the email addresses to which the email needs to be sent. I do not manage to bypass this isue. Does anyone have an idea how I could send the same email every week with Zapier ? I also tried to do this in 2 steps : Step 1 : Update a google sheets with the list of email addresses to which I want to send the email Step 2 : for these email adresses, send every wednesday the same email Unfortunately I am reaching the same issue, which is that the trigger (schedule every wednesday) does not contain the email address. I have the feeling I am missing something. Thanks,David
Possible to update existing Amazon S3 file?
Hi, new to Zaps!I have a google sheet which is updated daily (adding new rows and changing the existing rows)There is a column that is the index to the date the last change was made.I want to upload the google sheet to S3 (aws - i need it to reach the BI tool “quicksight”), and i want the added rows and updated rows to change based on the index column.I do not understand if the changes can be created in s3 or does it create a new file in the bucket every time?
How to transfer articles from Instapaper to Notion?
Hi , Is any detailed explanation about how to setup the process for sending data to Notion DB? today, when I read some articles on internet, I save them in Instapaper. However, notion is my 2nd brain so that I would like to transfer those articles / news / info to an appointed DB in Notion. Have anyone tried this before? /Peter
How to send a CURL Request with dynamic values?
I would like to send use this CURL Request:curl --data "api_key=demokey&webinar_id=demo123&first_name=FirstName&last_name=LastNameemail@example.com&schedule=0" https://api.webinarjam.com/everwebinar/register Some of the data (eg. first name) will be given from a trigger.Unfortunately I am a total newbie and don’t know how to do this.Please HELP me!I tried this - but it’s not working:
Getresponse and mailchimp workflow
So I want to integrate getresponse and mailchimp via zapier. What I wanted to happen is this: User will signup in my getresponse landing page → user info will be stored at getresponse lists → user info will be stored at mailchimp audience/list → will email the user (every new user that signs up) with a text email. the content of the email is just the same for every new user. → END
How do I create a JSON file with a zap?
Hey there,I am looking for a solution that creates a downloadable JSON file.Current situation: I store data in google spreadsheet, export it as csv and convert the csv into JSON using csvjson.com.I want to automate these steps in way and tried to create google doc template with the JSON structure, which is filled with data from the spreadsheet. However, the file cannot be downloaded as JSON from the google doc. And even when exporting it as txt file and rename it to .json, the file is corrupted. Do you have any ideas or suggestions to achieve this?Thank you all in advance
How to set up triggers for exact funnel, lead stage in amoCRM?
Hi all!I apologize in advance if my question is silly, but I can't figure out how to solve my problem.I'm trying to make a ZAP amocrm-jira software cloud.How can I configure trigger for amocrm to trigger only for THIS funnel and for THIS status in that funnel?I have several different funnels in ammocrm with different set of statuses inside.Right now the trigger "Lead Status Changed in amoCRM" works on ALL funnels and tracks ANY status changes.Thank you very much in advance for your help!
Is there a way to turn off a Zap with a trigger?
Hello! I am in the process of building out an automation sales funnel for a client and lately have been feeling like I'm in funnel hell! Seemingly endless options and none that quite do all the things I need them to. I finally decided to build something out from scratch relying heavily on Trello and Zapier that would work for my client's purposes. I am attempting to use a sequence of delayed Amazon SES emails within a zap to act as a very manual drip campaign. The only problem is that I don't know how to stop the sequence if somebody moves onwards to the next step. So my question is…. Is there a way to use a trigger or some other method to turn OFF an extended zap that is in-process? Thanks in advance!
Pass checkbox value from Webflow to Hubspot
If no record create one but if there’s an existing record update it
Hello all, this is my first question to the forum, and I’m sure it’s a dumb one, so apologies…I want to take a value, do a lookup, write that value to a new record if it’s not found, or simply continue on to update the existing record with other data if it IS found. I’d like to do this without using paths as everything after the IF statement will still apply, and be the same actions.I’ve looked at continue only if but that doesn’t seem to be the way, because I want to continue either way: with a new record, or with an updated record. This is an internal zap so I don’t have different apps to deal with, just a new form.Thanks for any help.
How to prevent Zap from triggering when Google Sheets when rows are sorted?
I’m an “amateur” Zap user so I hope this doesn’t sound like a simple/stupid question :-) I have a Google Sheet with many columns of data, including some that have dates.I’m trying to create a Zap that sends Emails when I change the Date in one particular column. That’s the easy part. What I can’t figure out is how to make it so that if/when I re-sort/re-order the lines on the spreadsheet, the system doesn’t think I’ve changed the Date in EVERY row.EXAMPLE: Sheet is sorted in Alphabetical order, so the Line I change is Row 10. I understand how to make this action occur.But if/when I re-sort the Sheet by the order of a different column, ALL the rows are reordered and the system then thinks I’ve changed the Date in ALL of the rows and the action is triggered for every row. I just need the action linked/tied to that one row regardless of re-sorting and so the system won’t respond every time I re-sort the Sheet. Does that make sense?Any help you can provide is appreciated.
How to sync Jira statuses to Salesforce and vice versa
I’m syncing the Salesforce Opportunity into a Jira Epic, mostly the workflow statuses for both are the same. In case there is a demand to change the statuses in workflows to be equal I can make that change, (but I would rather keep the modified Jira workflow as I have automations based on it).Priority 1: How do I create a Zap to sync the change in Jira Epic to reflect the status change in Salesforce.Priority 2: Make bi-directional status changes=>in addition to Priority 1 change the Salesforce status change in Jira Epic.Hope this is possible with Zapier.
Stop to split value in WooCommerce product attribute?
Hi,I connect bubble with Woocommerce by zapierI have Product Attribute “Photographer” and full name as value “Jonny Prezz”But when I create Zap I get a product with 1 attribute “Photographer” and 2 values “Jonny”, and “Prezz”I even try to add “line-item to text” before WooCommerce action. But the same mistake…Do you have any idea?Thanks in advance
How to create a record in CRM and then open that record in CRM in new tab via URL
Hi we are now using a system for our leads that has the ability for webhooks.I can trigger a webhook and I am able to create a lead in our other CRM using zapier app integration.What I want to be ale to do is once created I want to open the crm page as a new tab in broswer on the newly created lead so we can fill in more data and process that lead into member in new system. is there an app or something I can use to do this in in zapier? or is there a way to call a webhook to do this?I just want to call a url in a new window with the response returned from CRM app.Calling a url should be easy so I am sorry if I am missing something very straight forward.Thanks
Is there any way to continue a zap where a step fails, and pull the information it found?
This is very specific, but there is no employee ID look-up for Quickbooks Online.I have found that when creating a “New Time Activity” the Zap step CAN see the employee ID that is hidden in the QBO UI when you select an employee name from a dropdown.My goal is to use the “custom” tab and enter a variable that contains the Full Name, read the Employee ID reference, then pull that Employee ID reference into the “real” New Time Activity and populate the Employee Name field with that value. The Zapier “Employee Name” field takes a name, however the QBO portion will fail unless it is the Employee # found below said name. Is there any way to run a step “halfway” then continue and use that data in another step?Thank you,
Remove links and phrases, using Text Formatter?
Is there a way to remove links, or anything after a trigger phrase like “https”, from a text string using Text Formatter?For example, I am trying to create a Twitter > Discord automation. Tweets with “.,” at the end will be posted by Zapier, however I’d like to remove the “.,” and the the “t.co” link at the end before it reaches Discord.
Already have an account? Login
Use your Zapier credentialsLog in with Zapier
Log in to the Community
Use your Zapier credentialsLog in with Zapier
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.