• Instructions to Ask a Question

    For any assistance, please click the "Ask a Question" button and select the Pabbly product for which you require support.

    We offer seven comprehensive applications designed to help you efficiently manage and grow your business:

    Our support team endeavors to respond within 24 business hours (Monday to Friday, 10:00 AM to 6:00 PM IST). We appreciate your understanding and patience.

    🚀 Exclusive Lifetime Offers 🚀

    We invite you to take advantage of our special one-time payment plans, providing lifetime access to select applications:

    • 🔥 Pabbly Connect — Lifetime Access for $249View Offer
    • 🔥 Pabbly Subscription Billing — Lifetime Access for $249View Offer

    Make a one-time investment and enjoy the advantages of robust business management tools for years to come.

Google Sheets -- New or Updated Spreadsheet Row

xtinnna

Member
I have a workflow that triggers updates between Google Sheets and Notion, where any updates to my Google Sheets spreadsheet should trigger the same update in Notion so that the two databases mirror each other. Basically, if data is added to Google Sheets, I want Pabbly to add a new row with the new data. However, if any of the rows in Google Sheets are updated, I want Pabbly to update the specific row in Notion that corresponds to the relevant row in Google Sheets.

I noticed that my workflow was adding a new row every time a row in Google Sheets was updated, and I figured this was because I originally set the Action in Notion to be "Create Database Item." Thus, I decided to change the Action to be "Update Page" (note that there is no option for "Update Database").

The "Update Page" trigger requires the Page ID with the instructions stating "You can find the Page ID by the "Search Page" action event. E.g. 816ceca9-g17c-4ee7-0e91-5a3ba951c741." I went ahead and added a Search Page action and then mapped the result for Page ID into Update Page.

Screenshot 2025-01-06 at 11.32.41 PM.png


screenshot-2025-01-06-at-11-35-20-pm-png.51742


However, when I tried to Save and Send Test in the Update Page action, I got a validation error with the message "Invalid property identifier date." I have no idea what this means and need help.

Screenshot 2025-01-06 at 11.27.59 PM.png
 

Attachments

  • Screenshot 2025-01-06 at 11.35.20 PM.png
    Screenshot 2025-01-06 at 11.35.20 PM.png
    73 KB · Views: 133

Preeti Paryani

Well-known member
Staff member
Hello @xtinnna,

It appears that the date mapped under the date field (as shown in the attached image) is not in the required format, which is causing the issue. Please ensure that the date is mapped according to the format mentioned in the help text (refer to the attached screenshot). You can use the Date/Time format to get the date in the correct format.

1736236927656.png
1736236934073.png
 

xtinnna

Member
Hi @Preeti Paryani,
This is actually a bit frustrating because Pabbly specifically instructs users to use ISO format, which is the reason why I created a special column for every date field in my Google Sheets spreadsheet that converts the date to ISO. In fact, I mapped those ISO fields to corresponding Notion date fields when previously running the "Create Database Item" action and had no problems.

I'm not even sure how to convert the date to comma-separate format as displayed in your screenshot.
 

Preeti Paryani

Well-known member
Staff member
Hello @xtinnna,

Could you please provide a short recording or a screenshot showing the field type of all the date fields and the date format used in those fields? This will help us better understand the issue and assist you more effectively.
 
Top