Google Forms - send responses to Telegram/Discord

Questions & Answers
, ,
1

Hi all,
Loving Make - so glad I discovered it.
Trying to work out the best way to send a summary of responses to a Google Form to telegram/discord. The form asks people to fill out a Multiple-choice grid question, ranking the finishing order of drivers in the upcoming grand prix. The row labels are the driver names, and participants select what position they will finish in (1st - 10th or out of the points).

I’d like to be able to use the data to send a summary of what people predicted in the following format:

1st - Driver
2nd - Driver
3rd - Driver
… and so on

I thought of using an “If” function in the mapping section, (eg: IF(Driver1=“1st”,“Driver Name”,etc) but I can’t work out how to return the question name which is also the driver name. choose the Question name but it returns [collection] rather than the name of the question.

I hope this makes sense - very keen to hear if anyone has any ideas to make this easier!

Thanks
Denis

2

Welcome to the Make community!

Can you provide a link to the form, or show us a screenshot of how this looks like?

Have you set up a scenario to watch new Google Form submissions, and can you provide an example output bundle of this trigger module?

1. Screenshots of module fields and filters

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

You can upload images here using the Upload icon in the text editor:
Screenshot_2023-10-07_111039

2. Scenario blueprint

Please export the scenario blueprint file to allow others to view the mappings and settings. At the bottom of the scenario editor, you can click on the three dots to find the Export Blueprint menu item.

Screenshot_2023-08-24_230826
(Note: Exporting your scenario will not include private information or keys to your connections)

Uploading it here will look like this:

blueprint.json (12.3 KB)

3. And most importantly, Output bundles

Please provide the output bundles of the modules by running the scenario, then click the white speech bubble on the top-right of each module, save the bundle contents in your text editor as a bundle.json file, and upload it here into this discussion thread.
Screenshot_2023-10-06_141025

Providing the 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!

2 Likes
3

Thanks, here’s a link to the form (feel free to have a go at filling it out haha): https://drive.google.com/uc?id=1VJXKto58Iz90oulCRCRgPeFPrgAwjBu2

blueprint.json (346.7 KB)

Blueprint is updated above.

Can’t get any of the output bundles yet. Can upload later if i can.

4

The form link doesn’t seem to work. Perhaps you can upload a screenshot of what the questions look like instead.

If you can upload a copy of the trigger module output bundle that would help the most.

1 Like