Export all iCloud voice memos

export-all-voice-memos.bash

#! /bin/bash
newdir="allvoicememos"
mkdir $newdir
cd $newdir
OIFS=$IFS
IFS='|'
sqlite3 ~/Library/Application\ Support/com.apple.voicememos/Recordings/CloudRecordings.db "SELECT ZPATH, ZCUSTOMLABEL, ZDATE FROM ZCLOUDRECORDING" | while read line; do
	thisline=($line)
	location=${thisline[0]}
	name=${thisline[1]}
	date=${thisline[2]}
	offset="978307200"
	newdate=$(bc <<< "$date+$offset")
	trimdate=${newdate%.*}
	formatteddate=$(date -r $trimdate +%y%m%d%H%M.%S)
	echo "Location: $location. Name: $name. Date: $date. New Date: $newdate. Trimdate: $trimdate. Formatted: $formatteddate New filename: $newfilename"
        newfilename="./$name-$trimdate.m4a"
        cp $location $newfilename
	touch -a -m -t $formatteddate $newfilename
done
IFS=$OIFS

Original source: https://discussions.apple.com/thread/253230259