Export bookings to Google Sheets

Viewing 4 replies - 1 through 4 (of 4 total)
  • Plugin Author yoancutillas

    (@yoancutillas)

    Hello Scott,

    It’s working on my side,

    – Make sure you have made a CSV export. Select the CSV tab in the export dialog, and then press the “Generate Export Link” button. The link is different each time you press the button. (documentation #4.)
    – Don’t forget the quotation marks in the importdata formula: =IMPORTDATA(“https://your-secret-address.com/…“)

    Thread Starter SLRC

    (@slrc)

    Rereading the documentation on Google’s site. Seeing clearly the quotes, changing my formula. Seeing data. Hiding in a corner in shame.

    Is there a column that just has the Start Time? Or a different way to format the dates?

    Probably a different topic.

    Thanks

    Thread Starter SLRC

    (@slrc)

    All good, thanks

    Plugin Author yoancutillas

    (@yoancutillas)

    No problem ??

    There is the “Start date” column showing the starting date and time,
    Then turn ON the “Raw data” option in the dialog, and generate a new export link,
    You will be able to format that column in Google Sheets to show only the time (docs).

    Else you can add a custom column showing only the time with custom code thanks to the API.

Viewing 4 replies - 1 through 4 (of 4 total)
  • The topic ‘Export bookings to Google Sheets’ is closed to new replies.