Find answers to your questions. Ask the Community for help or hire someone to help you.
Unexpected token < in JSON at position 0. Having issues connecting from Google Sheets to AislePlanner
Hey Team, I have had success connecting from my website to a Google Sheet when filling out a form for new customers to show interest in our business. I’m trying to connect that Google Sheet to AislePlanner, but I continue to get the error - Unexpected token < in JSON at position 0. I went back to make sure my API code was correct and it shows I’m connected to AislePlanner, but I can’t get the test to go through to AislePlanner as a New Lead. Any help is appreciated as I’ve tried this 5 times now. Briana
HiThis is what I’m offering to my customers: they can buy an online course on my website and gets (on a start date he chooses) 21 motivational/supportive/informative text messages for the upcoming month.So, example:Buy the course on 23 januari.Start date of the text messages: 28 februari. (The start date so much ahead in the future makes sense in combination with other stuff that I sell)Thus:1) via zapier I subscribe the customer to the specific course in thinkific. (± 9 steps/tasks)2) via zapier I send the 21 messages, each day 1 message. (± 24 steps/tasks)What I encountered during development: https://zapier.com/help/create/customize/add-delays-to-zaps=> The most easy way would be to add a delay of 24hrs. But there’s a limitation to it. The delay cannot be > 31 days. (and there’s a maximum amount of stuff you can put into the delay).If found a workaround: => Quite a smart trick; just make a new calendar entry and then trigger it (with a different zap) when it starts. Did thi
I would find a use for a small number of Zaps, 5 or fewer, but at least one of them needs to be multi-step. For my purposes the current paid plans are more than I need, and as I am retired I don’t want to spend ~$20 p.m. A plan that allows 3-4 multi-step Zaps for < $10 would suit my needs. Or maybe allow trading off steps against Zaps? So a 2-step Zap counts as two towards the limit of five on the free plan? Maybe if I’m smart enough I could set up a two-step Zap as two single-step ones. Hmm, that’s a thought...
Hi! I have a Zap that takes any new rows in Google Sheets and sends me a new notification to a Slack Channel. I’ve had it for over a year and it suddenly started giving me empty responses in the notification (the notification was still happening, but the info from the row was empty) After troubleshooting a bit, I found that the info pulled from Zapier isn’t complete, it shows empty cells even though they’re not empty in the spreadsheet. This is from the Trigger test, but it also shows on the Zap history. All of those columns are filled on the spreadsheet: I tried creating a new zap from scratch, using a different google account with access to the spreadsheet, using a zap with Google Forms instead of Google Sheets, using the Team Drive option and everything gave me the same error. Any ideas would be greatly appreciated!
I did a lot of work inside my zapi logged in today and its all gone but my browserr history shows everything and even my account profile idi might have ended up creating different account, just confused right now i need help to locate this zap cos i followed a 6 hour tutorial to set it upplease help me locate my account
Hi,I’ve created a zap to integrate Google Sheet and Trello and it works great.But before putting it in production, I’d like to get clarification on the Zapier security policy.Both integrations need a data access which seems to be too broad when we just need 2 items to work together.Which guarantee does Zapier provide that will make sure that no enterprise data will be accessed through these kinds of integrations?
In the development stage and looking to use Typeform to capture leads and then distribute captured leads via email to various recipients. While I realize that can be done with relative ease, is there any way to distribute these captured leads to email addresses within with a zip code radius? Users will define their zip code as well as their preferred radius in the Typeform. I appreciate any advice as to the feasibility of this as well as the Zapier integrations that could make this happen. Thanks!
I’m trying to map from an event created in Calendly to an event created in either Microsoft Outlook or Microsoft Office 365. The event is created, but the neither the attendee nor the location are being carried over, and as a result the invitee is not getting an Outlook invitation automatically sent by Outlook. Any fix? This post has been edited by a moderator to remove personal information. Please remember that this is a public forum and to remove any sensitive information prior to posting. Thanks,Erik
Hi all, Is there a way to replace an entire worksheet? Meaning:In Airtable I add, adjust and delete records. I've added the ‘last modified time’ column, but if you delete a record, this is not “seen” by Zapier The added, adjusted and deleted records I want to copy to Google Sheets. I want to update the entire worksheet from my AT base. Zapier doesn't ‘see’ the deleted records as deleted and doesn't trigger an action. Is it possible to just replace the entire worksheet as soon as something changes? Thanks in advance for your help.
adding a webhook to create a ticket for new users. connecting to jira service desk looks successful, as well as selecting the project, and request type.however it doesn’t pull all the fields i want to populate. it pulls the string fields but the “Start Date” field doesn’t appear. are date fields supported? i see in other posts that it is showing up?the field is definitely in the project/request type/form. I can make it required which makes the ZAP fail error 400. Thank you!
I am trying to setup so that each time I receive a text message to a dialpad number that the text message is saved in a Google Sheet. Everything works EXCEPT there is never any content in the message saved. When I test the trigger the text always populates in the Sheet the way it should. however, whenever I run the Zap with a live text it logs everything EXCEPT the message. It’s driving me NUTS. Has anyone else had this experience and figured out a way round it?
Hi, I’ve already created a zap that creates a Google Calendar event when an event has been created in Salesforce. I now want to be able to update that same event if any of the details change in Salesforce. I’ve built this out so far but am still running into problems. Trigger - Update Record in Salesforce When testing the trigger, it seems like the record that’s being pulled from Salesforce is the original created event, rather than the updated event, so the event in the Google calendar never gets updated with the new details. Action - Find Event in Google Calendar To find the event, I inserted an ID into the original event when it was created and am using this to find that event in the ‘Search term’ field. Action - Update Event in Google Calendar When selecting the Event I want to update, I’m not sure what to select as I can’t seem to select the event found in step 2 above
Hey there, I’m trying to create a Zap to FWD receipts that come from one specific email to my Quickbooks receipt forwarding address. I need to include everything in the original email. So far I have only been able to set up a Zap to send a new email (instead of forwarding the original). How do I set up this automation?
Dear Community,I use Webinarjam and Hubspot for sign ups and webinar execution. To connect the two, I already have a zap in place that sends sign up data from Hubspot to Webinarjam. I now want to update a contact property in Hubspot to reflect who attended a webinar and who missed it. For this, I created a zap that takes the live attendees from Webinarjam, finds the contact in Hubspot and updates a contact property to “Yes, attended”. The test zap was successful, unfortunately the trigger for the Live Attendee in Webinarjam is only an instant trigger. Can this sync also be done after the event (webinar was yesterday) or will it only be available for triggers of live attendees that attend future events?Thank you and bestDaniela
How can I map “Job Title” from Rocket Reach to PipeDrive Person as an “update”???I want this field to map from Rocket Reach into PipeDrive “Job Title” field, but the only Data Inputs permitted in this zap Setup Action map to “Email” and “Phone” in PipeDrive, there is no option for Job Title (If I leave this data point here, it gets dumped in the email field of course) Is there another solution to build a connection using the API key from the PipeDrive “Job Title” field?
Like the title says, I’ve got a CSV that comes to Zapier with two top rows. Looks like this:Some text The actual header row, col2, col3, etc. Value 1, Value 2, Value 3, etc.BTW – this file lives in an SFTP directory. No Google Sheets or Excel. Just a CSV.Is there a way to indicate that the actual header row starts with row 2? Any other ideas for a solution? Much appreciated Zapier friends.
When using the slack workflow builder and “More steps by Zapier”, none of the apps will connect. Under “Connection”, it just says “Add New Connection” even though I already added my google/microsoft/etc account in Zapier. if I click “add new connection” and sign in again, it then says “ Our test had some issues:• We could not find that connection. Please try again.”How can I fix this? This happens with each app I try either google sheets, excel, microsoft todo, etc.
New to Zapier.Is it possible to initiate a Microsoft Power Automate flow based on an existing app integration trigger with the free version of Zapier?Existing Zapier App Integration > Event Trigger > Action > Power Automate flow runsI don’t mind building the action myself e.g. REST call to the Power Automate API endpoints.
I’m having an issue setting the timezone on a Google Calendar invite. My Google account and Zapier account are both set to PST timezone. I want to pass through an invite with AET (Australia Eastern Time) as the timezone. Everytime I try it sets the invite to PST. I have tried Australia/Adelaide which I found on another thread but that didn’t work either. I know I could use PST but the issue is that daylight saving dates are different between PST and AET and it would be a pain in the butt to figure out for the users going forward. Below is a screenshot of the data that is being picked up from a Google sheet. There are definitely spaces between. Am I missing something really obvious? Help!
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.