Logging sub names in Google Sheets

You can use the eventsub to catch subscriptions. There probably is some kind of API for Goodle Spreadsheets that you can use to put the data into a worksheet.