Create a new Google Sheet and set up columns exactly as shown:
Sheet 1 named Companies — columns: ID | Name
Sheet 2 named Contacts — columns: ID | CompanyID | Name | Role | Phone | Email | Notes
(Notes column stores all notes as pipe-separated entries like: Text||Date|Text||Date)
2
Go to Extensions → Apps Script and paste the Apps Script code provided in the README (included alongside this file). Deploy it as a Web App with access set to Anyone. Copy the deployment URL.