The test panel shows actual execution - not a simulation. Actions will really run, APIs will be called, and data will be processed. Use test data when possible.
Google Sheets Testing
When testing Google Sheets, it can sometimes take a minute for new rows to populate in the test panel. Be patient - this is because of the Google API.