I have a simple google sheet with a name, and twitter url in two or three columns. And what I want is for the twitter api to pull all the tweets from the row with the twitter URL and put it into the row and single cell next to it. So even if the Url pulls 100 tweets I want all 100 tweets to appear in the one cell in the row next to the twitter url. and then have it repeat that process for each twitter url in the google sheet. Important I only want the api to be activated when the button is pushed on the google sheet.
- I need a button or hyperlink created in google sheets in row column next to twitter URL to trigger Twitter API
- I need twitter api to pull tweets from the twitter handle or Twitter URL and place it in the row/column next to it and I need all the tweets from that URl to appear in that one cell.