This topic was automatically generated from Slack. You can find the original thread here.
Hello everyone! This project is an automated workflow designed to streamline the process of extracting and organizing information from business cards into a structured Notion database. Using OCR technology, the workflow scans uploaded images of business cards to extract key details like name, company, address, role, contact information, and social media handles. The extracted data is then formatted using AI (ChatGPT) into a JSON structure and automatically added to a predefined Notion database. This system eliminates manual data entry, ensuring accuracy and efficiency in managing contact information.
Listed is the components of the workflow!
Trigger (Google Drive - New Files)
Detects when a new file is added to a specified Google Drive folder, serving as the workflow’s starting point. Filter
Ensures the file meets specific criteria (e.g., file type or naming convention) before proceeding to the next steps in the workflow. OCR_Extract_Card_Info (Node.js)
Uses OCR (Optical Character Recognition) to extract text information (such as Name, Company, Email, etc.) from the uploaded business card or document image. Custom_Request (ChatGPT Integration)
Sends the extracted text data to ChatGPT for further processing or refining (e.g., formatting the extracted text into structured JSON). Record_Card_Info (Notion API - HTTP Request)
Sends the processed data from ChatGPT to the Notion API, specifying the correct properties and formatting to create or update a record. Add_Card_Into_Database (Notion Database Action)
Adds the finalized and structured information to the designated Notion database as a new entry, ensuring all relevant fields are populated.
I’d like some help on getting the technology to actually work. I’ve compiled everything as need be and the workflow seems to work fine but it’s not pasting the data it’s scraping from the Business Card and Transferring it over to the Notion Database. Any words of advice, things I should look for, etc would be greatly appreciated. I’ve also attached the properties in my database on Notion.
Ask our bot @U05A7KLNALC, simply mention it and ask the question
Connect with Pipedream Service Partner: Connect with a Pipedream Service Partner. They are experts in building with Pipedream and will be happy to connect with you to discuss building what you need.
You can connect with a Pipedream Service Partner for specific use case help by visiting this link. They are experts in building with Pipedream and can assist you with your needs. If you need further support, you can also visit Support - Pipedream for more options.
Hello everyone! This project is an automated workflow designed to streamline the process of extracting and organizing information from business cards into a structured Notion database. Using OCR technology, the workflow scans uploaded images of business cards to extract key details like name, company, address, role, contact information, and social media handles. The extracted data is then formatted using AI (ChatGPT) into a JSON structure and automatically added to a predefined Notion database. This system eliminates manual data entry, ensuring accuracy and efficiency in managing contact information.
Listed is the components of the workflow!
Trigger (Google Drive - New Files)
Detects when a new file is added to a specified Google Drive folder, serving as the workflow’s starting point. Filter
Ensures the file meets specific criteria (e.g., file type or naming convention) before proceeding to the next steps in the workflow. OCR_Extract_Card_Info (Node.js)
Uses OCR (Optical Character Recognition) to extract text information (such as Name, Company, Email, etc.) from the uploaded business card or document image. Custom_Request (ChatGPT Integration)
Sends the extracted text data to ChatGPT for further processing or refining (e.g., formatting the extracted text into structured JSON). Record_Card_Info (Notion API - HTTP Request)
Sends the processed data from ChatGPT to the Notion API, specifying the correct properties and formatting to create or update a record. Add_Card_Into_Database (Notion Database Action)
Adds the finalized and structured information to the designated Notion database as a new entry, ensuring all relevant fields are populated.
I’d like some help on getting the technology to actually work. I’ve compiled everything as need be and the workflow seems to work fine but it’s not pasting the data it’s scraping from the Business Card and Transferring it over to the Notion Database. Any words of advice, things I should look for, etc would be greatly appreciated. I’ve also attached the properties in my database on Notion.
To troubleshoot the issue with your Pipedream workflow not transferring data from the business card to the Notion database, here are some steps and tips you can follow: 1. Check OCR Extraction: Ensure that the OCR step is correctly extracting the data from the business card. You can add a logging step after the OCR extraction to verify the extracted data. This will help you confirm that the OCR is working as expected. 2. Verify ChatGPT Processing: After the OCR step, ensure that the data sent to ChatGPT is being processed correctly. You can log the response from ChatGPT to verify that the data is formatted into the expected JSON structure. 3. Inspect Notion API Request: Double-check the HTTP request being sent to the Notion API. Ensure that the request includes all necessary headers and the payload matches the expected format for your Notion database. You can refer to the Notion API documentation for details on the required format. 4. Check Notion Database Properties: Verify that the properties in your Notion database match the fields you are trying to populate. Ensure that the property names and types in the JSON payload align with those in your Notion database. 5. Test with Sample Data: Try sending a sample JSON payload directly to the Notion API using a tool like Postman to ensure the API request is correctly structured and the Notion database is accepting the data. 6. Error Handling and Logging: Implement error handling and logging throughout your workflow to capture any errors or issues that occur during execution. This can provide insights into where the process might be failing. 7. Review Pipedream Logs: Check the logs in Pipedream for any errors or warnings that might indicate where the workflow is failing. Logs can provide valuable information about the execution flow and any issues encountered. 8. Consult Pipedream Support: If you continue to experience issues, consider reaching out to Pipedream support for further assistance. You can visit Support - Pipedream for more support options. By following these steps, you should be able to identify and resolve the issue preventing data from being transferred to your Notion database. If you have specific error messages or logs, feel free to share them for more targeted advice.
