A script to transform an ad hoc spreadsheet configuration into a CSV suitable for import as Mautic Contacts
This Python script reads data directly from a Google Spreadsheet, reorganises it, and formats it as double-quote enclosed comma separated values suitable for import into a Mautic contact database.
Getting Google Spreadsheet access credentials
You must have a Google Dev account.
Used this howto: https://developers.google.com/sheets/quickstart/python
Testing this script
You have to define the sheet you're wanting to access, the credentials to use (you must've shared the sheet with the email in the credentials) and then resulting
'''python contactconvert.py'''