CF7 to Google Sheets Missing Random Submissions - The Quota Problem Nobody Explains

A site owner posted on the WordPress forums that their CF7 to Google Sheets integration was dropping about a third of submissions. Email notifications were being sent. The submission was saved in the form plugin's database. But one in three never made it to the spreadsheet. Another user confirmed the same pattern. A third user said it had worked...