Automorphy of mixed Tate motives over $\mathbb{Z}$
You seem to be starting with the answer and trying to deduce the question.
By Langlands philosophy every motive should correspond to an automorphic form. [...] What makes $M^1_n$ automorphic?
I think it's a very interesting philosophical question: if (simple) pure motives correspond to (maybe cuspidal, algebraic, etc) automorphic representations, then should non-semisimple mixed motives correspond to? However, the answer is far from obvious. So we don't know yet what the question "is $M^1_n$ is automorphic?" should mean, which makes it very difficult to answer it in any meaningful way.
What is true is that one can construct lots of interesting examples of mixed motives (or, at least, of their realisations) using modular curves, or more general Shimura varieties. E.g. a very good way of constructing and studying elements in groups like $Ext^1(Q(0), Q(n))$ is to look at the behaviour of Eisenstein series at cusps of a modular curve. But there isn't yet a general theory of "mixed automorphic representations" that gives a unified explanation of all these constructions.
David is right: there isn't yet a general theory of "mixed automorphic representations". Let me propose some ideas of what a theory could be.
First, I will work with the $p$-adic realizations of mixed motives, rather than with the the mixed motives themself, for concreteness and because motives are harder to construct that Galois representations.
I don't think that it is reasonable to expect that every $p$-adic non-semisimple Galois representations (with Fontaine-Mazur-like conditions) should come from an automorphic representations. In fact, I don't even know what "come" would mean here : to an algebraic automorphic representation, say for $Gl_n$ or for a reductive group G together with a representation of its $L$-group into $Gl_n$, I know at least conjecturally how to attach a semi-simple Galois representations, not a non-trivial extension.
Rather, I expect non semi-simple Galois representations (with suitable local conditions that makes them "motivic") would all come from $p$-adic deformations of automorphic form (in the sense of eigenvarieties). Rather than to try to formulate this in general (that would be mostly guess-work), let me consider an interesting very particular case.
Let $F$ be a number field. I consider extensions of $\mathbb Q_p$ by $\mathbb Q_p(1)$ in the category of $G_F$-representations, which are unramified outside $p$ and crystalline at $p$. The spaces of such extensions is naturally isomorphic, as is well-known (Kümmer Theory ++), to the space $\cal O_F^\ast \otimes_{\mathbb Z} \mathbb Q_p$, whose dimension is determined by Dirichlet's unit Theorem to be $[F:\,mathbb Q]-1$.
Say $F$ is totally real to fix ideas (and different from $\mathbb Q$) because in this case the eigenvariety of over convergent $p$-adic automorphic forms for $GL_2/F$ has been constructed (Andreatta-Iovita-Pilloni-Stevens). There is a (unique) point $x$ on this eigenvariety corresponding on this the Eisenstein series $E_2$ over $F$ with critical refinements at every place above $p$.
The eigenvariety carries a family of Galois representations (rather a pseudo-representation) which at $x$ is the (semi-simple) representation $\mathbb Q_p \oplus \mathbb Q_p(1)$ but is irreducible at points near $x$ (that's a consequence of the choice of "critical" refinements). If you choose any curve $C$ in the eigenvariety through $x$, smooth at $x$, and restrict your family of Galois representation to $C$, and even to the local ring of $C$ at $x$, then the famous "Ribet lemma" gives you an extension of $\mathbb Q_p$ by $\mathbb Q_p(1)$ in the category of Galois representations of $G_F$, unramified outside $p$ and crystalline at $p$.
We can say that this extension is (the $p$-adic realization) of a mixed motive, automorphically constructed.
Then in this special case, you question can be precisely formulated:
Conjecture: All such extensions of $\mathbb Q_p$ by $\mathbb Q_p(1)$ comes from a deformation of $E_2$ this way.
I don't know if that's true beyond the trivial $[F:\mathbb Q]=2$ case. But I think it is reasonable to expect this. A student of me, Yu Fang, proved it is true when the eigenvariety is smooth at $x$.
This answer is a slight addition to Joel's and David's.
In the theory of Galois representations, there is a general philosophy that $p$-adic phenomena (say in Hida families or eigenvarieties) reflect corresponding mod $p$ phenomena. So before asking if all extensions of $\mathbb Q_p(n)$ by $\mathbb Q_p$ can be constructed automorphically, one could ask the corresponding question mod $p$. Here is a slightly more general version, for the number field $\mathbb Q$: if $\psi$ and $\chi$ are two mod $p$ Dirichlet characters (of some conductor), thought of as Galois characters, whose product is odd, can any extension of $\chi$ by $\psi$ be realised in the reduction mod $p$ of a lattice in the (irreducible) $p$-adic Galois representation attached to some cusp form.
I think that the answer to this (and more general version of this) question is believed to be yes (folklore), and perhaps is even known to be yes in the particular case I just discussed. Questions of this type are certainly discussed in Skinner--Wiles: I think they will show that if you have a $p$-adic lattice in an irreducible representation whose reduction gives some extension class, then there is a cusp form giving rise to this extension. (They will need to assume ordinary at $p$, but actually recent work of L. Pan will let you replace ordinary by a more general Fontaine--Mazur-type condition.) Part of their technique is to move from one possible extension class to another. (Kisin used to call this ``Skinner--Wiles tunnelling''.)
I don't know if it's known that every extension of $\chi$ by $\psi$ actually can be lifted to a lattice that is ordinary (or, more generally, geometric) at $p$, though. If it were, one would get a positive answer to the mod $p$ version of the problem in some cases.
On a different note, I believe that Harder (and probably many others too) studied extension classes of automorphic motives arising from Eisenstein cohomology classes, and in this way constructed (or proposed construtions for) actual mixed motives, rather than just Galois representations. The first example of this would be looking at cohomology of open modular curves, or of complete modular curves relative to the cusps. One obtains mixed motives this way, but by Manin--Drinfeld, if you work over $\mathbb Q$ you get split extensions --- non-splitness only occurs with torsion coefficients. I think you can get more interesting things if you both delete some cusps, and then work relative to others (so that the weight filtration on cohomology has length three rather than just two), although it's been a long time since I thought about it (Mazur mentioned these ideas to me, in conjunction with Harder's name, when I was a grad student). I don't know what happens on higher dimensional Shimura varieties, but work of Harris and Zucker on mixed Hodge theory of Shimura varieties is probably relevant.