Home > database >  Send perfectly aligned tabular text message in Google Chat Space using webhook
Send perfectly aligned tabular text message in Google Chat Space using webhook

Time:08-24

I have created a Google chat space. I have a script which does some calculation and the final data is in pandas Dataframe. I want to send the data in this Dataframe as Daily alerts in tabular form in the chat space. What have I tried

# sample pandas Dataframe to be sent as alert
df = 
    SYMBOL      LAST        TIMESTAMP
0   20MICRONS   102.15      19-AUG-2022
1   21STCENMGM  27.50       19-AUG-2022
2   3IINFOLTD   45.90       19-AUG-2022
3   3MINDIA     22859.80    19-AUG-2022
4   3PLAND      17.45       19-AUG-2022
5   5PAISA      281.25      19-AUG-2022
6   63MOONS     188.50      19-AUG-2022
7   A2ZINFRA    12.80       19-AUG-2022
8   AAKASH      12.80       19-AUG-2022
9   AAREYDRUGS  35.20       19-AUG-2022

Using enter image description here

Whereas the same message if sent to Microsoft Teams channel the table is perfectly aligned.

CodePudding user response:

The issue is that Google Chat uses a proportional font by default, and for this type of line drawing you need a enter image description here

  • Related