[Bug]: Empty rows considered as header in Google Loader #1828
Description
What happened?
In rare cases, when a Google Sheet contains an empty row at begging it will be parsed as a header, leading to the skipping of the whole sheet.
Example: https://docs.google.com/spreadsheets/d/1GzB5mEc7FPf8p_RFcUSuANtwtAB5OwOxLMwd2OV7mo0/edit
How to reproduce?
$extractor = new GoogleSheetExtractor(
'https://docs.google.com/spreadsheets/d/1GzB5mEc7FPf8p_RFcUSuANtwtAB5OwOxLMwd2OV7mo0/edit',
'1234567890',
new Columns('Sheet', 'A', 'Z'),
);
$rows = $extractor->extract(flow_context(config()));Data required to reproduce bug locally
Google Sheet loader
Version
0.22
Relevant error output
No error, just empty result.