Doesn't "not good" in this context mean NEVER. Are there any native tribes/peoples that had a writing system before European contact? AFAICT, it's one of the main causes so many native languages are dying/extinct.
Writing developed in America long before Europeans showed up and continued to be used until Europeans showed up, but the Europeans destroyed most books they could find and forced the natives to learn the colonizers' languages. That's the main cause why so many native languages are dying/extinct.
It looks like writing developed in present-day Mexico and never made it north of the desert border (Mojave/ Sonoran/ Chihuahua). So NONE of the estimated 296 languages spoken by natives in US and Canada had a written language that we have evidence of. [0]
"An extensive Mesoamerican literature has been conserved, partly in indigenous scripts and partly in postconquest transcriptions in the Latin script."
It also says:
"The Florentine Codex, compiled 1545-1590 by Franciscan friar Bernardino de Sahagún includes a history of the Spanish conquest of the Aztec Empire from the Mexica viewpoint"
Having a writing system and using it to record history are surprisingly independent. For example, in ancient India they wrote all kinds of stuff down, but virtually none of it is history. Most of what we know about the history of India comes from the records of other peoples who came into contact with the Indians.
There's at least one script that's absolutely, a 100% definitive written language, Maya. There are about half a dozen more that qualify for certain reasonable definitions of writing. Beyond that, there are hundreds of systems of proto-writing that rely primarily on the cultural context of the speaker to interpret. These were still used to record events and stories, though.
Further reading: https://en.wikipedia.org/wiki/Mesoamerican_writing_systems