Unfortunately, Twitter allows only 3 tiers of permissions. ListTweet requires both Read and Write permissions as it creates Lists for you based on underlying clusters automatically. https://developer.twitter.com/en/docs/apps/app-permissions
It would be interesting if you could extend this to have a 2 way duplex connector from something like Airtable to Postgres. Airtable could represent the last n records at any given point of time. I'd pay for that product. Not so much into Google Sheets.
