Hi @Kled
Unfortunately currently it's not possible to send surveys to Google Sheets without the apostrophe. We use it to prevent users from data loose.
Your topic is not the first that raises the problem.
I think we could add an option in ODK Collect that would allow sending data without the apostrophe, it should contain a description and be disabled by default to make sure only aware users use it. Would that solve your problem?