I just want to sync a plain table with HubSpot. Either Google Sheet, Airtable or whatever. If it works with a specific table, I will switch to that table.
So, I tried Google Sheets. All the tools don't work: Sheet Director, zapier, make and much more. I tried 8 different tools. Because an email is always mandatory, but in our list, there are people without an email address. Importing is of course possible, but I think Hubspot should be able to sync data, at least just a usual table should be possible.
Using Airtable didn't work, because Airtable determines your primary key that cannot be changed and let alone cannot be allocated to two columns.
Additionally, in Hubspot I cannot create lists without basing that list on filtering.
