Hi. Create a datastore (and it’s data model) is simple. But you can’t do bulk inserts. You need add the records / rows individually in flow. It’s fast too, even for 1000 records it will takes only a few seconds.
Here is a guide that can help you:
If you have questions reach out
Ohh, I hope you didn’t run all your 1000 records because you will have to redo them.
Here is the solution. When using the Add a Record module, you can also map value to the key to set your desired key value for each record. If you leave it blank then the system will generate it automatically (and that’s what happened here).
For future reference and if it’s an option, you can also simply add a column to your Google Sheets doc, that is a continuous count up (1, 2, 3 etc.). Then map that column to the Key field when creating the record. Saves you operations