Google Sheets Data Showing up as dots

What are you trying to achieve?

Hi Folks, I am new here. I am using Chipp to send data to Make via webhook to Google sheets

Steps taken so far

The whole process is a success except data shows up as dots not data. Data from Chipp is a date and then text. I have formatted the Google sheets for plain text and the date for date. I have formatted columns for autofit to text. Make run shows success. But an occasional warning pops up. When I check this all the details have been lost from my Google sheets module in the scenario, I re input them and then it works again. Not sure why the google sheets formatting is being lost(please view screenshot). Any advise on the dots in google sheets(please view screenshot)and how this can be turned into input text data would be great.

Welcome to the Make community!

To allow us to assist you with your scenario, please provide the following:

1. Relevant Screenshots

Please share screenshots of your scenario, any error messages, relevant module fields, and filters in question? It would really help other community members to see what you’re looking at.

2. Scenario Blueprint

Please export the scenario blueprint file to allow others to view the mapped variables in the module fields. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

3. Output Bundles of Modules

Please provide the output bundles of the modules by running the scenario (or get from the scenario History tab), then click the white speech bubble on the top-right of each module and select “Download input/output bundles”.

Providing the input/output bundles will allow others to replicate what is going on in the scenario even if they do not use the external service.

Following these steps will allow others to assist you here. Thanks!

Thanks Samliew, App

r
arently no bundles were generated by this “operation”. So nothing to download. See seen shot. I have uploaded other files previously. I notice that I do get files delivered, and I assumes that once sent to Google sheets they were deleted from MAKE?
blueprint.json (19.9 KB)
Attached is the json file. Thanks for helping me with this ciao Cathy

If Chipp is not sending data, then there is no data to be mapped/ used/ saved.

You will have to investigate it further on Chipp’s end, including contacting their support on how to set it up correctly.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Hi Samliew,
Thanks for taking a look at this. However the data is being sent through from CHIPP. Check out this screenshot. Once the data is sent onto sheets, it returns to zero. So something is happening. Any help would be great.

I get it now. You have to set your scenario’s schedule to “Immediately”.

Then Save, switch your scenario off and then on again. It will prompt you to delete all the data in the queue, or process all the older requests first.

Then, leave your scenario ON.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

Hi samliew, Thanks for the help with this. Unfortunately when I set to immediately I get a spinning wheel. Please image. It just spins till I stop it. This is why I set it to 2 mins.

e
I think the data bundles get through to Google sheets but the formatting is not right. Just shows up as dots in google sheets. I bet there is just one simple thing I am not doing.

Instant Triggers

This is because the module is an INSTANT (webhook) trigger, and not a POLLING trigger.

There are two main types of triggers, Polling (scheduled), and Instant (webhooks). Polling triggers can only run on a schedule. Instant triggers can be run as soon as data is received by the webhook.

  • Polling means Make checks external service for changes (pull changes to Make).
  • Webhook (instant) triggers means external service calls Make when there are new changes (push changes to Make).

If you run a scenario with an instant trigger, and it gets “stuck” on the trigger module, this means it is READY and WAITING for an incoming request. You basically need to trigger something for it to be instantly received by the scenario.

To find out more on the different types of Trigger modules, see refer to Types of Modules and Webhooks sections of the Make Help Centre.

Hope this helps! Let me know if there are any further questions or issues.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.

My take on MAKE so far is : the AI is useless.

I have been going round in circles trying to make this work for about a week and nothing suggested, fixes the issues.

This is what I am trying to do I want to create a scenario that takes input from Chipp and sends it to a google sheet. Google Sheet is Super-Voice-Comments-Template - Google Sheets

Column headers are Date, Subject, NAme Comment The information input by the user in Chipp is to be stored in these columns in google sheets using Make.

The user in Chipp can access the information in the Google Sheets via prompts for summaries and reports from the Google sheets stored info. The information in google sheets is private to each user. To be verified by Chipp login which would be an email address. I do not want to add additional cost by using 3rd party supplies of others to provide triggers etc - I want to do this with in MAKE, which is why I signed up. Supposedly MAKE could well make the webhook work.

The tutorials are fairly tedious and do not seem to be able to provide info specifically on what I am trying to do.

Basically the app needs to store user input, the access user input to answer prompts from Chipp. Persistent memory of inputs and access to an updating file. There may be other ways to do this. I am pretty desperate and will listen to anything you suggest.

I need some help to do this. Is there a way someone could do it for me or at least guide me through the process? If you can suggest someone that would be great, what would it cost.

Did you know, this forum has a Hire a Pro category, where you can post your request for off-site specialised help on other platforms (video call/screenshare/private messaging/etc.)? This may help you get your issue resolved faster especially if it is urgent. It is important to post your request in the Hire a Pro category, as forum members are not allowed to advertise their services (even offer FREE assistance to help) in other categories like here. Once you have posted in the Hire a Pro category, that will allow other members like me to provide booking links to our calendars for a free consultation and video assistance (including screenshare)!

Here are some useful links and guides you can use to learn more on how to use the Make platform, apps, and app modules. I found these useful when I was learning Make, and hope they might benefit you too —

Getting Started

Help Centre Basics

Articles & Videos

If you have any further questions, please repost in the Hire a Pro category if you find it easier to book a free expert consultation to explain your problem over screenshare. There is only so much we can do for you on a text-based forum.

@samliew

P.S.: Investing some effort into the Make Academy will save you lots of time and frustration using Make.