I realized that when I use the “google_sheets.append_sheet” service to insert data into a table, the worksheet’s name cannot contain a colon. This
- service: google_sheets.append_sheet
data:
config_entry: [Your Google Sheets ID]
worksheet: "Try this: see what happens"
data:
Column 1: some data
Column 2: some more data
doesn’t work. It only works without a colon (of course the worksheet in Google Sheets has to have the same name):
worksheet: "Try this see what happens"
Is there any way around it, so that the colon and probably other special characters are taken as normal text (like I would have expected)?
The error message I receive with the colon variant is:
{'code': 400, 'message': "Requested writing within range ['Try this: see what happens'!A3], but tried writing to column [B]", 'status': 'INVALID_ARGUMENT'}