HubSpot to MySQL Data Sync

This repository contains a JavaScript application that allows you to synchronize contact and company data from HubSpot to a MySQL server. This README provides step-by-step instructions on how to set up and run the application.

Prerequisites

Before you begin, make sure you have the following prerequisites:

MySQL server is installed and running.

Installation

Clone this repository to your local machine:

git clone https://github.com/yourusername/hubspot-to-mysql-data-sync.git

Change into the project directory:
```
cd hubspot-to-mysql-data-sync
```
Install the required Node.js packages by running:
```
npm install
```

Configuration

Create a config.json file in the project root directory and add your HubSpot access token and MySQL credentials as shown below:

{
 "hubSpotAccessToken": "<your_hubspot_access_token>",
 "mysql": {
     "host": "localhost",
     "user": "root",
     "password": "<your_mysql_password>",
     "database": "hubspot"
 }
}

Database Setup

Set up the required MySQL tables by executing the SQL scripts provided in contacts.sql and companies.sql in your MySQL server.

Usage

To synchronize contact and company data from HubSpot to MySQL, follow these steps:

Copy Contacts

Run the following command to copy contacts from HubSpot to MySQL:
```
node contacts.js
```

Copy Companies

Run the following command to copy companies from HubSpot to MySQL:
```
node companies.js
```

License

This project is licensed under the MIT License - see the LICENSE file for details.

This README provides detailed instructions for setting up and running the HubSpot to MySQL data synchronization application. Make sure to replace <your_hubspot_access_token> and <your_mysql_password> with your actual HubSpot access token and MySQL password in the config.json file.

devadigax/HubSpot-to-MySQL-Data-Sync-with-JavaScript