Author : @vishalx360
This tool generates CSV files for pull requests made by a single user. You can import these CSV files into Google Sheets and then copy the data into a Notion table.
-
Clone the Repository: Clone the repository to your local machine using Git.
git clone <repository-url>
-
Install Dependencies: Navigate to the project directory and run the following command to install the required dependencies.
npm install
-
Configure Env:
-
Go to the bitbucket pull request page and select the project and author.
-
Copy the URL of the page.
-
create a
.env
file in the root directory of the project. -
Add the following line to the
.env
file:url=<URL>
-
-
Get JSON Data Link:
-
Run the command:
npm run link
-
Copy the JSON data link generated.
-
-
Paste JSON Data: Create a file named
input.json
in the root directory of the project. Paste the JSON data obtained from the previous step into this file. -
Generate CSV File: Run the following command to generate the CSV file.
npm start
-
Locate CSV Output: Once the process is complete, the CSV file will be generated in the
output
folder within the project directory. -
Import to Google Sheets: Import the generated CSV file into Google Sheets.
-
Copy Data to Notion Table: After importing the data into Google Sheets, copy the relevant data and paste it into the designated table in your Notion workspace.
These steps aim to simplify the process and provide clear instructions for each stage of the workflow. If you encounter any issues or have questions, feel free to reach out for further assistance!