News:

LATEST RELEASE:  FPP 8.1 - Download from here - https://github.com/FalconChristmas/fpp/releases/tag/8.1

+-+-

+-User

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+-Site Stats

Members
Total Members: 16645
Latest: muzzwh
New This Month: 9
New This Week: 4
New Today: 1
Stats
Total Posts: 133920
Total Topics: 16690
Most Online Today: 90
Most Online Ever: 7634
(January 21, 2020, 02:14:03 AM)
Users Online
Members: 2
Guests: 52
Total: 54

Integrating Twilio with Google Sheets

Started by Nufernandes, September 09, 2023, 07:15:33 AM

Previous topic - Next topic

0 Members and 1 Guest are viewing this topic.

Nufernandes

First off, thank you to the contributors on the Twilio Plugin, Love the possibilities it offers.

I have Twilio setup, and working. When I text a name to my Twilio number it sends the webhook to FPP and the name comes up on the matrix. I dont want to publicize the number, because my 16 yr old self would be leaving the light show and constantly texting the matrix...(I'm not that guy anymore). I haven't figured out a way to limit the text to one per person, so I decided to create a google Form, which I can limit by IP Address.

I have the Form set up, and the Sheet that gathers the results. In the sheet I inserted the code that is attached, and setup a trigger to execute the code when a new entry is submitted.

When I enter a name in the form, the sheet collects the response, and executes the code.
The log file shows that the request is being made to Twilio and Twilio accepted it, by returning a '200' code.
the response line seems to be blank in the log file, and the name entered in the form never comes through to the matrix, or the messaging queue.
If I text the name, it comes through right away.

I am hoping that by attaching the code and the log files here, some can see something I may be missing.

I know the FPP and Twilio settings must be correct because its working via text, I just cant get it to do the same via the webhook script in the Form.



Nufernandes

@dkulp  can you help if you have a few minutes to review the attached code?

dkulp

Gut feeling is the scope of the "var response" variable.  You are defining it within the "if" and thus I believe it's no longer set outside of there.   That said, I know little about Apps Script so I could be off.
Daniel Kulp - https://kulplights.com

Nufernandes

thanks for the suggestion, I will keep tweaking it.

Support FPP

+- Recent Topics

Pi 5 does not boot with fresh image of 8.2 by jumblinjim
Today at 10:03:42 AM

Weird date / time issue by k6ccc
Today at 07:22:14 AM

Having problems upgrading my system from WLED to FPP with differential receiver by MikeKrebs
November 04, 2024, 08:35:49 PM

Getting an error on Initial Set up of v 8.2 FPP by MikeKrebs
November 04, 2024, 08:24:42 PM

F48 Output Issues - Pixel Strand by dbarton02
November 03, 2024, 01:52:25 PM

F16 v5 invalid file by JonD
November 03, 2024, 11:08:00 AM

3D Printable X-Connect connectors by dreiman
November 03, 2024, 09:47:45 AM

Does the Falcon f16v4 support TM1814 RGBW LEDs? by btm231
November 02, 2024, 11:08:38 PM

LED panel formatting issue ? by Unibits
November 01, 2024, 05:18:54 AM

Solution for USB Dongle not appearing in FPP for colorlight card by darylc
October 31, 2024, 07:17:43 PM

Powered by EzPortal
Powered by SMFPacks Menu Editor Mod