Power Platform Community Forum Thread Details

Save Tweets to Google Sheet stops loading

I am new to Flow, and I just started playing around with templates available in the librariy. I am super excited about Flow, I noticed one strange behavior though: When using the Save Tweets to Google Sheet flow, the process stopped multiple times (I ran that flow for 24 hours).

I've tested the service with tweets on Microsoft, and due to the volume per hour, I was expecting to get roughly 28,000 tweets within 24 hours. For that purpose, I expanded my Google Sheet to it's limit of 40,000 rows. However, I just got roughly 4,000 records. I went through my sheet, and I noticed that the flow was stopped 4 times within that 24 hours run. After 24 hours, I turned that flow off.

Also, I would like to know which template to use if I want to load Tweets to an Excel Spreadsheet on OneDrive? Thanks in advance.

Hi @RafaelKnuth,

Could you please share a screenshot of your flow's configuration?

Do you use the "Save tweets to a Google Sheet" built-in template to create your flow?

Further, do you want to save tweets to a Excel file stored in your OneDriver folder?

I suppose that you use the "Save tweets to a Google Sheet" built-in template to create your flow, is it true?

I could not reproduce your issue on my side currently. The "When a new tweet is posted" trigger of your flow would be fired when a new tweet that matches a given search query is posted, if the new tweet could not match the search query that you specified within the Search text field of the trigger, your flow would not be triggered.

More details about the "When a new tweet is posted" trigger of Twitter connector, please check the following article:

"When a new tweet is posted" trigger

In addition, if you want to save tweets to an Excel file (Whose data has been formatted as an table) stored in your OneDrive folder, please take a try with the following workaround: