It used to be easy to analyze your Twitter data: you'd go to your settings and ask for a download, and there among all the files would be a CSV file full of your tweets and the associated metadata.
This guide will walk you through the basics of automating data cleaning in Google Sheets using Python and Pandas.