just getting the hang of this:)
Thank you for providing more information about your use case. It seems like you’re trying to sync data from a Google Sheet (connected to a Google Form) to a Notion calendar database, but you’re facing issues with the date and time formatting. To help you with this issue, I’ll need to know how you’re currently handling the date and time data in your Pipedream workflow. Are you using any specific code or pre-built actions to process the date and time from Google Sheets before sending it to Notion? Sharing a code snippet or the steps you’re using in your workflow would be helpful in identifying the problem and suggesting a solution.
thanks yes, i am using the format_iso8601_datetime helper in between
It seems like you’re using the format_iso8601_datetime helper to format the date and time from Google Sheets before sending it to Notion. To better assist you, can you please provide the code snippet where you’re using this helper function? This will help me understand how you’re processing the date and time, and suggest any necessary adjustments to resolve the formatting issue.
hmm, we seem to be going in circles a bit
i think i already provided the requested info about
Apologies for the confusion earlier. Since you’re using the format_iso8601_datetime helper to format the date and time from Google Sheets before sending it to Notion, let’s try to adjust the formatting to match Notion’s requirements. Please replace the current usage of format_iso8601_datetime with the following code snippet: const formatDateForNotion = (dateString) => { const date = new Date(dateString); return date.toISOString().replace(".000", ""); }; const formattedDate = formatDateForNotion(yourGoogleSheetsDate); Replace yourGoogleSheetsDate with the variable containing the date from Google Sheets. This code snippet will format the date in a way that should be compatible with Notion’s date and time field. After making this change, try running your Pipedream workflow again and see if the date and time are correctly synced to the Notion calendar database. If you still encounter issues, please let me know, and we can explore other solutions.
hi could we try another issue? in the same workflow, the cover photo is not displaying correctly in notion, although that is not displaying as an error in pipedream
I understand that you’re facing an issue with the cover photo not displaying correctly in Notion, even though there’s no error in Pipedream. To help you with this issue, I’ll need more information about how you’re handling the cover photo in your Pipedream workflow. Are you using any specific code or pre-built actions to process the cover photo before sending it to Notion? Sharing a code snippet or the steps you’re using in your workflow would be helpful in identifying the problem and suggesting a solution.
thank you this workflow is
google sheets trigger > notion_create_page_from_database
no custom code
Since you’re using the Google Sheets trigger and the notion_create_page_from_database action without any custom code, the issue with the cover photo might be related to how the data is being passed between the two components. To troubleshoot this issue, please follow these steps: 1. In your Pipedream workflow, click on the Google Sheets trigger step and inspect the output data. Check if the cover photo URL is present and correct in the output. 2. Next, click on the notion_create_page_from_database action step and inspect the input data. Make sure the cover photo URL from the Google Sheets trigger is being passed correctly to the Notion action. 3. If the cover photo URL is being passed correctly, but the issue persists, it might be related to how Notion handles the cover photo. In this case, you might need to add a custom code step between the Google Sheets trigger and the Notion action to process the cover photo URL in a way that’s compatible with Notion. If you need further assistance, please provide more information about the structure of your Google Sheet and the Notion database, including the specific columns and properties related to the cover photo.